Haha, it's definitely missing a couple of a features that would be nice from the visualization perspective. I love the ease of sharing capabilities through the service, the data modeling and DAX components along with what's possible within the visualization layer. But it's not a perfect product and the Power BI team continues to push out updates to improve the product! :)
Is there a way to do this on a filled map or ArcGIS map? I'm trying to show a data label (that's already a column in my excel) over the middle of a census region (already added lat/long for middle of each census region). I can get this map, and I can separately get a filled map, but can't find a way to do both. This took 5 seconds to do in Tableau not sure why it's not an automatic option in Power BI
i have a question, how can lock the zoom level after finishing the work on the map ? i mean i want to show just a part of the map, the idea is when i finish setting the map, i want to zoom in a part of it and after that fixing this zoom to not be modified, to always focusing on one part of the map, could you help ?
Hello Again, i had the same issue, your method worked with me very well, but there was another issue, the filters didnt work with the map, for example i have 100$ sales in morocco, the 100$ did not change if i filter by departement or projects could you help ?
I've been using the Tooltips feature to create data labels. So far, they only appear when you hover but it's a much simpler option for someone who may have some difficulty with formulas
is there any method to show just the data lables ? i mean just the numerical values without showing the name of the state and showing the datalables at the exact location on the map could you help please ?
Thank you. I haven't used PowerBI before. May I know, is it possible to do conditional formatting on the data labels on the map. For example, if total sales < 100, the data label colour is red.
Thank you Mitchell for this very interesting video, I have a question about the aggregation. In my report, I have a slicer for the transaction type and it works well : it makes the right sum of the values for the chosen type. But, when I introduce a slicer date, it doesn't work : in fact, when I have only a value in the values column, it's ok (one value for one month). For example, for France, if I have one transaction type, one month, I have the right value. But, if I select two months, I have two values in the labels (because I have two values in the values column, one by month). It doesn't make the sum of the two values. Obviously, if I don't select any month, I have the same problem. Any idea to fix it ? Thierry
I found out that if you create the calculated collum as you did and just chuck that into location, Power BI would recognize the location (it works for me). So basically skipping the longitude and latitude part.
Hey, thanks for a great video! However, I get an error saying that 'Caluculate is not allowed as part of calculated column DAX expressions on DirectQuery models'. Anybody knows how to solve that?
Thank you Mitchell! That's was a very good one! By the way, I have a question: I created the table, like you did, with the name Geography and the relationship was made with my table. Now, I'm tryng to create a filter, with the information that I have in my table, for example, Client Name. If I insert the variable Client Name oh the visutal of the map, and select a random client, the filter dosent works. Do you know what to do?
Hello, I'm looking for labels as purely numbers only without any country name mentioned in the label.If anyone has a solution for that it'd be really helpful. Thank You.
Thank a lot Mitchell😊 I follow your tip and the result is great but when I need to change or filter year like 2023 or just 2024 it doesn't change follow, it's still show total calculate (2023 + 2024). And anyone know how to fix it? Thank you ✌️🏻
Hi Mitchell - your video was great! Is it possible to do the same to provide for % of Sales versus the SUM of sales. Could you provide a demo if this is possible. Thank you so much
Kindly could you give us other examples for how to show specific data labels in longitude latitude in maps with many ways, because i have just longitude latitude data without location, thank you so much
Hey man, thank you for your awesome tutorial. I need some help for a particular task. Can you please make a tutorial on how to show dot density in bing/google map? For example if New York has 50 shops, I want to show 50 points/dots in map. Can you help me do this?
Thank you so much for this tutorial. I am trying to do something similar, but rather than displaying sales data, I want to display how many occurrences of a situation per state. The only way I know how to get the state count is by using a measure, but there doesn't look like there's a way to display that measure on the map, which is unfortunate.
You can do those aggregates in the calculated column, similar to my example where I did a sum on total sales. Because of row context your code may look something like COUNTROWS(RELATEDTABLE('SALES')). Relatedtable will allow you to use the existing relationship to filter down your sales table, then once properly filtered you would be able to count the rows. The biggest problem most people run into with these calculations is the fact that ROW CONTEXT exist and essentially disables those active relationships you have defined in the data model. I did a separate video a while back on ROW CONTEXT which can be very helpful here. Of course, the big limitation with Calculated Columns is that it won't be dynamic and react to the filter context in a report like calculated measures! I hope this explanation helps. Thanks!
@@MitchellPearson Thank you!! Yes, I see what you mean. The label now shows the state count, however, when I adjust the date range, they don't change. Interesting!!! I really wish this label/data feature was native to the program. I know it's possible in Tableau, but we're trying to avoid that route due to budget constraints. I really appreciate your help and I can't wait to watch more of your videos!
What is the trick that makes this work? Is it that you have State names in the column along with the data? Would this still be employable if you had locations defined by lat/long, and not at a city/state/etc. level?
I just use this technique to display names. Since we all work remote, we wanted to show the employees on the map to display the names on the dot on the map. So, I calculate lat and long defined as decimal for addresses for each staff member. I dropped the name into location. Its displaying staff's names. I also tried without the lat and long by formatting the location as "city, state: Person Name". Power BI is able to parse this but it displays the label with city, state and name. Which is not desirable.
how do we display the state names ? I want to display USA map only......With states name displayed on map. I have already tried all 3 options….Map, Filled map, Shape map And then finally used shape map. I have used state as location. But It displays state name , only when I Hoover over it. I want it to display permanently. I don’t have … Data labels option under ....Format Visual -) Visual Plz guide.
Hello MitchellPearson and the PowerBI GIS Community, I bumped into this video here and well if it helps, ArcGIS for PowerBI Map Visual has inbuilt labelling functionality. to access it you go to the more visual option and then add it into powerbi. The only requirement for you to work with it in PowerBI is that you need to signup for ArcGIS Online Account to be able to use it. Thank you Family
I am curious, EVERYONE does Sales / Finance related Power BI videos but those of us dealing with medical trends, especially those related to poverty, employment type, education level, access to health care, veteran status, etc...could use some assistance creating measures applicable to our world. For Example, I need a report to show the number of patients who meet certain criteria which is held in 3 separate columns (Diagnosis column must contain either Bipolar or Schizophrenia but there are 26 different codes that equal those two diagnosis. 2) they must have been given one of three blood test, also defined by 12+ codes in a separate column. Third, and in the last column, the patient must have been prescribed one of 20 different psychotropic medications, each represented by a different code. Current solution to show those who are compliant requires building 5 new columns and 3 new measures. Once compliancy is located, THEN I can display on a state map the hot spots for programs not succeeding in meeting the requirements. I'm seeking a more concise resolution. I'm happy to provide a spreadsheet of dummy data if necessary. Thanks for the GREAT training methodology!
man you saved my life! I was trying everything and this video was the solution. Thanks.
How come PBI is still so popular whilst missing such basic features like labeling?! But thanks for the workaround ;)
Haha, it's definitely missing a couple of a features that would be nice from the visualization perspective. I love the ease of sharing capabilities through the service, the data modeling and DAX components along with what's possible within the visualization layer. But it's not a perfect product and the Power BI team continues to push out updates to improve the product! :)
Thanks for the trick but this map is not getting filtered nor interacted with other available dropdown filter
Is there a way to do this on a filled map or ArcGIS map? I'm trying to show a data label (that's already a column in my excel) over the middle of a census region (already added lat/long for middle of each census region). I can get this map, and I can separately get a filled map, but can't find a way to do both. This took 5 seconds to do in Tableau not sure why it's not an automatic option in Power BI
i have a question, how can lock the zoom level after finishing the work on the map ? i mean i want to show just a part of the map, the idea is when i finish setting the map, i want to zoom in a part of it and after that fixing this zoom to not be modified, to always focusing on one part of the map, could you help ?
I have a question Mitchell, how do you connect the Sales by State data with slicer (for example: Year slicer)
Hello Again, i had the same issue, your method worked with me very well, but there was another issue, the filters didnt work with the map, for example i have 100$ sales in morocco, the 100$ did not change if i filter by departement or projects could you help ?
I've been using the Tooltips feature to create data labels. So far, they only appear when you hover but it's a much simpler option for someone who may have some difficulty with formulas
is there any method to show just the data lables ? i mean just the numerical values without showing the name of the state and showing the datalables at the exact location on the map
could you help please ?
Thank you. I haven't used PowerBI before. May I know, is it possible to do conditional formatting on the data labels on the map. For example, if total sales < 100, the data label colour is red.
Very Clever!!!!! Omg i was racking my brain and could not figure it out. I'm coming from mapping in Tableau which has data labels.
It's honestly so surprising and frustrating that PBI doesnt have this basic function. Like the most basic lol
Very useful video presented with excellent clarity. Really appreciate your effort.
very helpful trick! thank you
Thank you for the useful video. Can data labels be added using either Shape Map or Mapbox in Power BI?
Thank you Mitchell for this very interesting video,
I have a question about the aggregation.
In my report, I have a slicer for the transaction type and it works well : it makes the right sum of the values for the chosen type.
But, when I introduce a slicer date, it doesn't work : in fact, when I have only a value in the values column, it's ok (one value for one month). For example, for France, if I have one transaction type, one month, I have the right value. But, if I select two months, I have two values in the labels (because I have two values in the values column, one by month). It doesn't make the sum of the two values.
Obviously, if I don't select any month, I have the same problem.
Any idea to fix it ?
Thierry
This is amazing! Very creative solution! Greetings from Brazil!
Thanks Michel! Glad you liked it and have a great 2021 :)
Hi guys, there is no "average" in the menu. How to fix it?
This works like a charm. Thanks for the solution!
Great information, i want task in my toolbar of lattitude & longitude there is no average option, how to solve that?
Did u solve this problem? I'm trying to label some data and there is no option to aggregate
I found out that if you create the calculated collum as you did and just chuck that into location, Power BI would recognize the location (it works for me). So basically skipping the longitude and latitude part.
Hey, thanks for a great video! However, I get an error saying that 'Caluculate is not allowed as part of calculated column DAX expressions on DirectQuery models'. Anybody knows how to solve that?
You can't create calculated column if you get data by direct query mode. You'll have to change import mode in your data source configuration
Thank you Mitchell! That's was a very good one!
By the way, I have a question:
I created the table, like you did, with the name Geography and the relationship was made with my table.
Now, I'm tryng to create a filter, with the information that I have in my table, for example, Client Name.
If I insert the variable Client Name oh the visutal of the map, and select a random client, the filter dosent works.
Do you know what to do?
Hey, Mitch...this is great. Question: How can I do this and allow the user to filter results on the needed date range? Is this possible?
You mean by adding date slicer?
Hello, I'm looking for labels as purely numbers only without any country name mentioned in the label.If anyone has a solution for that it'd be really helpful. Thank You.
Thank a lot Mitchell😊 I follow your tip and the result is great but when I need to change or filter year like 2023 or just 2024 it doesn't change follow, it's still show total calculate (2023 + 2024). And anyone know how to fix it? Thank you ✌️🏻
Hi Mitchell - your video was great! Is it possible to do the same to provide for % of Sales versus the SUM of sales. Could you provide a demo if this is possible. Thank you so much
Kindly could you give us other examples for how to show specific data labels in longitude latitude in maps with many ways, because i have just longitude latitude data without location, thank you so much
Awesome thanks! I used this theory to simply add a percentage of sales (ie: '12.6%' only) category label without the bulky state name label/text.
This tip just saves my day!
Hey man, thank you for your awesome tutorial. I need some help for a particular task. Can you please make a tutorial on how to show dot density in bing/google map? For example if New York has 50 shops, I want to show 50 points/dots in map. Can you help me do this?
Thank you so much for this tutorial. I am trying to do something similar, but rather than displaying sales data, I want to display how many occurrences of a situation per state. The only way I know how to get the state count is by using a measure, but there doesn't look like there's a way to display that measure on the map, which is unfortunate.
You can do those aggregates in the calculated column, similar to my example where I did a sum on total sales. Because of row context your code may look something like COUNTROWS(RELATEDTABLE('SALES')). Relatedtable will allow you to use the existing relationship to filter down your sales table, then once properly filtered you would be able to count the rows. The biggest problem most people run into with these calculations is the fact that ROW CONTEXT exist and essentially disables those active relationships you have defined in the data model. I did a separate video a while back on ROW CONTEXT which can be very helpful here.
Of course, the big limitation with Calculated Columns is that it won't be dynamic and react to the filter context in a report like calculated measures! I hope this explanation helps. Thanks!
@@MitchellPearson Thank you!! Yes, I see what you mean. The label now shows the state count, however, when I adjust the date range, they don't change. Interesting!!! I really wish this label/data feature was native to the program. I know it's possible in Tableau, but we're trying to avoid that route due to budget constraints. I really appreciate your help and I can't wait to watch more of your videos!
@@jessicabramow3094 @MitchellPearson I have the same issue as what Jessica is facing, do you have any suggestions?
Dear Mitchell! Loved the video, it worked out pretty well, and it was so easy to understand and replicate. Thanks.
Imagine those country names were products, can I add logos by them? Any idea?
Very well presented! Thank You for the tip!
How to show the result of a measure as label!
Very useful method thank you so much👏👏
Woooooooow! Genius! Thank you so much, just what I needed.
Great!!! It's awesome!! Thanks 🎉
great job on this approach
Thank you very much! This helped at work 🙂
Thanks. You helped me a lot at work
What is the trick that makes this work? Is it that you have State names in the column along with the data? Would this still be employable if you had locations defined by lat/long, and not at a city/state/etc. level?
I just use this technique to display names. Since we all work remote, we wanted to show the employees on the map to display the names on the dot on the map. So, I calculate lat and long defined as decimal for addresses for each staff member. I dropped the name into location. Its displaying staff's names. I also tried without the lat and long by formatting the location as "city, state: Person Name". Power BI is able to parse this but it displays the label with city, state and name. Which is not desirable.
how do we display the state names ?
I want to display USA map only......With states name displayed on map.
I have already tried all 3 options….Map, Filled map, Shape map
And then finally used shape map.
I have used state as location.
But It displays state name , only when I Hoover over it. I want it to display permanently.
I don’t have …
Data labels option under ....Format Visual -) Visual
Plz guide.
Amazing!!!! Thank you!
This is soooo much easier to do in tableau but thank you so much for saving my bacon.
Hello MitchellPearson and the PowerBI GIS Community, I bumped into this video here and well if it helps, ArcGIS for PowerBI Map Visual has inbuilt labelling functionality. to access it you go to the more visual option and then add it into powerbi.
The only requirement for you to work with it in PowerBI is that you need to signup for ArcGIS Online Account to be able to use it. Thank you Family
Hi, can you please show me which option helps to a data label feature in ArcGIS Map ?
Awesome vid thank you
Great! Very useful.
Muchas gracias! Lo máximo! :)
Awesome thanks!
Appreciated Mitchell
Awesome
Thanks Kashmir!
Thank you so much
Thanks a lot!
2:30 to skip the bullshit
muchas gracias
Thanks Simon!
This rools - thanks!
Thanks Linda!
2022 and still there are no easy way to add labels to a power bi map.
I am curious, EVERYONE does Sales / Finance related Power BI videos but those of us dealing with medical trends, especially those related to poverty, employment type, education level, access to health care, veteran status, etc...could use some assistance creating measures applicable to our world. For Example, I need a report to show the number of patients who meet certain criteria which is held in 3 separate columns (Diagnosis column must contain either Bipolar or Schizophrenia but there are 26 different codes that equal those two diagnosis. 2) they must have been given one of three blood test, also defined by 12+ codes in a separate column. Third, and in the last column, the patient must have been prescribed one of 20 different psychotropic medications, each represented by a different code. Current solution to show those who are compliant requires building 5 new columns and 3 new measures. Once compliancy is located, THEN I can display on a state map the hot spots for programs not succeeding in meeting the requirements. I'm seeking a more concise resolution. I'm happy to provide a spreadsheet of dummy data if necessary. Thanks for the GREAT training methodology!
Yes please! This is something I need too (but for veterinary-medicine)!