Видео

Now you can filter all tables at once 😅

I think this will help: www.skillademia.com/blog/pivot-table-slicer/#:~:text=However%2C%20if%20the%20%E2%80%9CReport%20Connections,the%20%E2%80%9CData%E2%80%9D%20group%20tools

Hopefully, u saw the video before trying to make the data model again from scratch in a new Excel file 😅😅

You are more than welcome ! :)

Thank you 😊😊

More than welcome 😊😊

Am not sure i understood what you mean. You can set the values of the y axis from the chart options. Feel free to look at the basic videos in my chart playlist

You are Welcome ! :)

U r welcome bro! Feel free to share the channel with anybody interested: ruclips.net/user/excelwizardinminutes?submission=1

Thanks Nahlas! Who knew u could do this in excel ? Hehe

This way, annoying users that click on everything would ruin ur dashboard 😅

You are welcome Paula! :) i hope all my videos are like this hehe

Hello, yes of course. You have to look at the comments before yours. Some ppl had issues and i listed all the possible options (such as not having a working key) i know about.

@@EXCELWIZARDINMINUTES Thank you for your time , the Problem i am facing is not listed in the commets before because i do have a working API key but when i use the formula to calculate the distance with the adress that i enter (form : street postal code city) it's always the #VALUE error

@@meryemwardani6769 try to use a normal address to get the latitude and longitude. for example Paris. Check if it works for you.

Sometimes, if the address is vague, it doesnt give you the lat and long

@@EXCELWIZARDINMINUTESit gave me the latitude and longitude with no Problem but it does not give me the distance between them.

I m glad u liked it! 😊

so nice of you to leave such a great comment :)

That s so nice of you! Please spread the word to colleagues and friends 😇 i m tryin to help as many ppl as possible with excel. I know excel can be such a headache!

U r welcome!😊😊

Great! 😊😊

Thanksss a lot! :))

You are welcome! :)

You are welcome! I struggled with that some time back :)

Check this: learn.microsoft.com/en-us/answers/questions/554110/excel-pivot-calculated-field-inactive-to-active

U have to follow the methods in the video. I suggest u try it on dummy data (like 20 - 30 lines of data) to get the hang of it before u do it on the full dataset

Hahaha cracked me up! In which country do u work?

You will have to go to the code. There is a formula that returns the distance with round. There u might have to do modifications. (Search for round in the the vba code)

Thank u Jim ! 😊😊

Thanksss a lot! :))

Thanksss a lot :))

Hopefully more to come! :))

Hahahah thank u! 😊

Thanksss 😊😊

Ohh thank you for the super nice comment 😍😍

U might have to be more specific with addresses (it s probably not catching the names), or u get ur lat long on google maps and use them in the distance and time matrix. Try one address on google maps (not excel) and see what it gives for lat long. That might tell you why it s not catching it properly and you can correct accordingly coz the api works like google maps.

You are welcome! :)

Thanks a lot! :))) I have put the India file in the same folder where I had the other ones. This way, Power Query will automatically load the file

You can convert between unit of measures easily. For the rest you might need to check the API documentation and potentially make modifications to the code

i just remembered, there is a line of code in VBA: GetDistance = Round(Round(WorksheetFunction.FilterXML(objHTTP.responseText, "//TravelDistance"), 3) * 1.609, 0) This is where you can play with round and the meters (1.609).

@@EXCELWIZARDINMINUTES Thank You, what about mode selection is it possible to change it to cycling method? Thank you so much for your feedback btw!

@@verrelnathaniel2741 Somebody asked me about this long time back in the comments. honestly, i ve never done it. here is what you can do. in the VBA code, there is a http request (ie some line with http) that calls the API. Have a look at the API documentation, I am sure they will tell you where you have to change this to get cycling, walking, etc...

Graciasss Sandra :))

I m glad i solved ur issue hehehe

I suggest you download the file: mega.nz/file/TCw2WKRJ#Mz7K0AgU0i6enV1Ozvr5vCc-MLGOT6vupVuAo4RfnaY Try to follow the instructions step by step and i m sure u will ace it! :)

​@@EXCELWIZARDINMINUTES This Yes i am getting it when I have only 1 row of category data as you have in your data, but my requirement is I am having for Examples: Group 1 -- Major cat 1 & Major Cat 2 & Major cat 3 Group 2 - Major cat 1 & Major Cat 2 & Major Cat 3 Group 3 - Major cat 1 & Major Cat 2 & Major Cat 3 As I have 3 rows after each group it's not giving this output, but when I have only 1 row like your dataset I am getting this result. Please help me how to do if I have 3 or more rows for each group. Thanks in advance

U only have 2 axis to do the work. In ur case, u might try to make several charts and make them one on top of the other one (removing border colot and chart area color)

Spot on! :)