Thanks in a million. Great content. Awesome. Very well explained. I couldn't find this explanation--simply put anywhere else. Great teachers are hard to find. Grade: A++💥
@MyOnlineTrainingHub
2 жыл бұрын
Thanks for your kind words, John 😊
@DiamondRock2
3 жыл бұрын
for sure that's what i am looking for but this is the first step in map and we are looking forward to see more videos about map, thank you Maynda and Phil.
@MyOnlineTrainingHub
3 жыл бұрын
Will keep it in mind, Mohamad!
@wayneedmondson1065
3 жыл бұрын
Hi Mynda and Phil. Thanks for sharing these techniques. Nice to know the possibilities :)) Thumbs up!!
@MyOnlineTrainingHub
3 жыл бұрын
Thanks so much, Wayne!
@IvanCortinas_ES
3 жыл бұрын
Thank you for these new contens in Power BI Mynda. Super tutorial!!!
@MyOnlineTrainingHub
3 жыл бұрын
Glad you like them, Ivan!
@salahhasan1365
3 жыл бұрын
Great tutorial, keep up the information flowing 👍🏻
@MyOnlineTrainingHub
3 жыл бұрын
Thanks, Salah 👍
@chrism9037
3 жыл бұрын
Great tutorial, thanks Mynda. Really cool
@MyOnlineTrainingHub
3 жыл бұрын
Glad you liked it, Chris!
@Devilchild7139
3 жыл бұрын
Amazing!! I have just enabled Power BI, so I will start off with UK maps. It takes me back. My first use of Pivot was to sort out historic sales data into sales territories when I was sales director for Wayne Kerr. I wanted to assess if the sale persons targets were fair by looking at the historic order book. If I had access to a map back then, my MD might have had half a chance of understanding what I was doing. I went ahead in any case----!
@MyOnlineTrainingHub
3 жыл бұрын
So pleased you'll be able to use it, Steven!
@darrylmorgan
3 жыл бұрын
Hi Mynda and Phil! Really Enjoyable Helpful Tutorial...Thank You Both :)
@MyOnlineTrainingHub
3 жыл бұрын
Glad you enjoyed it, Darryl!
@adriannacook313
2 жыл бұрын
Thanks so much, Phil and Mynda! I am hoping you would be able to give me some hints on how I can do the maps by region in NSW only. I need to represent the map for NSW which includes 7 regions: Greater Sydney, Hunter, North Eastern, South Eastern, North Western, South Western and Western. Thank you.
@vijayarjunwadkar
3 жыл бұрын
Nice video Mynda, thank you for sharing! I have benefitted a lot from your channel! Keep it up! 😊👍
@MyOnlineTrainingHub
3 жыл бұрын
Happy to hear that, Vijay!
@raghun9129
2 жыл бұрын
Hi Mynda, thanks for all your powerbi videos. its realy help to learn, im requesting you please do DAX formula vidios, and also some realtime senario videios, I belive you will do ,,,Once again Thanks for your valuable support.
@MyOnlineTrainingHub
2 жыл бұрын
Thanks, Raghu! I teach DAX in my Power Pivot course: www.myonlinetraininghub.com/power-pivot-course
@RoshenRRujj
Жыл бұрын
you saved my day!!! thanks!!
@MyOnlineTrainingHub
Жыл бұрын
Glad I could help!
@evanlo2569
6 ай бұрын
Hi Mynda and Phil, I have a Queensland map which Has 13 regions which have drawn up in CAD. I want to embed that in a spreadsheet and then link data as a filter to each region. Does the same method work?
@MyOnlineTrainingHub
6 ай бұрын
There is more on creating custom maps here: learn.microsoft.com/en-us/power-bi/visuals/desktop-shape-map#use-custom-maps
@philippreugschas234
Жыл бұрын
it's great to watch an english tutorial as a German - I learn a lot about Power BI while practicing my English. How do you say - to hit two flys with one stone? ;-)
@MyOnlineTrainingHub
Жыл бұрын
Glad you found my tutorial helpful 😊 the saying in English is 'it kills two birds with one stone'.
@kravishankar100
2 жыл бұрын
Thanks, Phil and Mynda, I am hoping you would be able to give me some hints on whether there is any way to add a label to each state in custom shape map.
@MyOnlineTrainingHub
2 жыл бұрын
I can't remember off the top of my head, but if there's not an obvious option in the formatting pane, then I'd say not.
@pitmandaniel
2 жыл бұрын
Super helpful video, thanks! :) Anyone else not able to see the Data Colors settings in the menu? I have only populated the Region and Colour saturation fields
@pitmandaniel
2 жыл бұрын
Nevermind, I was able to fix the issue by going to File > Options > Global > Preview Features > New format pane = unchecked
@MyOnlineTrainingHub
2 жыл бұрын
Glad you liked it, Dan!
@raeesg
3 жыл бұрын
Thanks for the video 😊, you mentioned a link for the github repository - where can this be found?
@MyOnlineTrainingHub
3 жыл бұрын
The link is in the Power BI file you can download from the link in the video description.
@sowmyakrishnam1444
Жыл бұрын
Am not having the conditional formatting option in shape map visual can anyone help me out
@jongcheulkim7284
3 жыл бұрын
Thank you. ^^
@MyOnlineTrainingHub
3 жыл бұрын
You're welcome 😊
@ОксанаЛащенкоСамарская
2 жыл бұрын
What should I do if the country I need is not in the drop-down list?
@theresabarnard8213
3 жыл бұрын
Excellent
@MyOnlineTrainingHub
3 жыл бұрын
Thank you so much 😀
@lindabond9307
Жыл бұрын
Unfortunately the Conditional Formatting tricks don't work anymore on the latest version.
@MyOnlineTrainingHub
Жыл бұрын
The Conditional formatting tools have moved, but they should still work.
@lindabond9307
Жыл бұрын
@@MyOnlineTrainingHub At 6:07 you discuss how to get the conditional formatting to sync between the map and the table, by putting the max/min value for Shape Map. New version of shape map already puts the max/min value BUT this does not sync it with slicers anymore. UPDATE - OK, so it's one of those strange things where if you remove the max/min numbers, and then enter them again, the colour sync works. Hope this helps new users
@imanetaghi391
Жыл бұрын
Hello , thank you for this video , but how we can add label s on this shape map please ?
@tewdrosberhanu8170
3 жыл бұрын
Hi Mynda, I am grateful for the work you do and Many thanks for the great lesson. On this lesson I was expecting to see the legend on the side of the map that show the saturation on the map. so is it possible to have a foot note or key legend on the side of the map to show the density of population that match the color on the map description? i was doing similar visual but could not figure it out on the shape map. Thanks1
@MyOnlineTrainingHub
3 жыл бұрын
There aren't any labels for the map, which is why we add a table. In practice the map won't generally be on its own. It'll be used in conjunction with other visuals which will give you that missing information like state/territory names.
@bartekd9885
9 ай бұрын
Regarding color coding - what if there is more of categories I'd need to show? I'm currently working on a project that might have up to 15 different categories which should be shown on custom shape map. Is there an option to do this, or should I look for some other than shape map solution?
@MyOnlineTrainingHub
9 ай бұрын
Don’t think so. 🤔
@sksanket
3 жыл бұрын
Hi Mynda, Thanks for this channel, I follow your videos from your first video itself, I learnt a lot from you virtually 😊😊😊. Now I have question or doubt here. I have huge data starting from Jan-20 till date ( Running), it has month and Quarters defined in it, whenever I need power query processes all the data which is time consuming job. Is there any way where I can select date range or Quarters to narrow down search criteria. Please suggest. Thanks and regards Sanket
@MyOnlineTrainingHub
3 жыл бұрын
Hi Sanket, you can filter out the data in Power Query that you don't need to import to your file. If you have further questions please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@sushreesangeetajena7646
Жыл бұрын
Hello. Great content. If I want to go one step further and locate cities of Australia as a drilldown option, how to get the cities map for australia.
@MyOnlineTrainingHub
Жыл бұрын
You'd have to use a different map visual that recognises cities or longitude/latitude coordinates. Try the 'Map' visual as opposed to the Shape Map visual.
@kvsider7599
Жыл бұрын
Is there a version of Shape Maps with bubbles?? I want to create a map of the US with bubbles but removing the ocean so that the shape of the US shines on top of the powerBI background i've chosen.. Is this posssible? Thanks!!
@kvsider7599
Жыл бұрын
The bubbles represent a value per city (NBA team victories)
@MyOnlineTrainingHub
Жыл бұрын
Not sure. Check out the custom visuals market place to see if there are any new charts that will work for your needs: appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals
@berhanumolla2445
3 жыл бұрын
well good, keep up miss
@MyOnlineTrainingHub
3 жыл бұрын
Thank you 😊
@parvizyakubov8350
6 ай бұрын
Hi, is it possible to reflect province/district names in shape map format?
@MyOnlineTrainingHub
6 ай бұрын
Not for most countries. You might be able to for the USA. Make sure the column heading reads 'County'.
@angelav7999
2 жыл бұрын
Amazing video and voice. Can you suggest how to create a shape map for a city? A city is divided by 200x200 meters and i have long and lat data
@MyOnlineTrainingHub
2 жыл бұрын
Thank you, Angela! Unfortunately, the shape maps aren't available at the city level of detail. You could try the 3D maps and use longitude and latitude: www.myonlinetraininghub.com/excel-3d-maps
@flovr1625
Жыл бұрын
Hey, thanks for this video! I still cannot find the conditional formatting tho. Theres no place where i can put in a formula and no since its a newer version it doesnt look like what is shown in the video. Can someone help? Is a special license needed?
@MyOnlineTrainingHub
Жыл бұрын
It looks like you can only set the fill colours in the formatting tab under Data Colors. It still has the same effect as that shown in the video.
@flovr1625
Жыл бұрын
@@MyOnlineTrainingHub I can set the color for each of the (over 200 different) values, but not for all of them in a formula or a colroing rule😕
@mercypena2200
2 жыл бұрын
Hi. Are tutorials 365? I have windows 2013 I could not find the shape map visual
@MyOnlineTrainingHub
2 жыл бұрын
The Shape Map is only available in Excel 2019 onward.
@2002ritesh
Жыл бұрын
How do I get City of Perth by it's suburbs on Map
@MyOnlineTrainingHub
Жыл бұрын
These maps can't show suburbs, but you can use a 3D map: www.myonlinetraininghub.com/excel-3d-maps
@khushbugupta6970
2 жыл бұрын
How to enable data labels?
@MyOnlineTrainingHub
2 жыл бұрын
Use the + icon in the right of the chart when the chart is enabled.
@khushbugupta6970
2 жыл бұрын
@@MyOnlineTrainingHub No, there is not any option to enable labels when using power BI shape maps
@shekhargr81
3 жыл бұрын
How to bring the state names into the shape map ?
@MyOnlineTrainingHub
3 жыл бұрын
This shape map doesn't have labels as an option. If you want to see a map with location information you can use the Filled Map which has the locations labelled.
@lindabond9307
Жыл бұрын
I think the Nationals would beg to differ .....
@MyOnlineTrainingHub
Жыл бұрын
😁
@ifoodieTV
Ай бұрын
You actually DID NOT share the file. That can be uploaded to POWER BI. This is simply a demonstration. Rule 1 of teaching. A person learns more by PRACTICING. You provide no files to practice.
@MyOnlineTrainingHub
Ай бұрын
This video isn't teaching you how to get data. To practice shape maps you don't need to upload the original file. You just need a Power BI file containing data you can use. If you want to learn Power BI, please check out one of my step by step Power BI report videos in my Power BI playlist: kzitem.info/door/PLmd91OWgLVSKQlDJaOF1XmKghKturU5qK&si=_cjR2rYY8WFAVFbf
@ifoodieTV
Ай бұрын
@@MyOnlineTrainingHub okay I will just blame KZitem. For bringing up this video in my search.
@User-xw4dt
3 жыл бұрын
Sorry, but Who ever needs this...?
@craigsmall7984
3 жыл бұрын
Whether you can see yourself using it or not, knowing that it's there to use, just in case, is valuable in itself. And you never know what bizarre report request is just around the corner ...
@gyozakeynsianism
3 жыл бұрын
Maps? Lots of people. Generating maps based upon your data? Lots of those people. I don't get your question really. I do this kind of thing in ArcGIS, but being able to do it in Excel sounds great.
Пікірлер: 81