Forum Discussion
Data Labels on Maps
brendaivett the only way I can think of to do this would be to have some Lat and Long coordinates for each State
You can pick any in each state that plot well on the map you'll be using - see picture
(you may do this in a separate table so you only do it once for each state)
Then create your State Count COLUMN to use in the Location field
State Count COLUMN = 'Table'[State]&" - "&CALCULATE(SUM('Table'[Count]), ALLEXCEPT('Table', 'Table'[State]))You can look at this post but I don't think it can be applied in your case
I was so looking forward to the ArcGIS Maps but we have even less flexibility there - for now.
I hope they add labels and tooltips soon.
Hope this helps! :smileyhappy:
Hi Sean,
I have a list similar to the following:
State --- Count
TX --- 10000
CA --- 5000
AK --- 250
OR --- 100
So in Power BI Desktop I convert the State column to the State or Province type, and then include the count in the value for the map, and that way it positions according to the State, but to see the values, I only see them in the tooltips.
If I concatenate State and Count, it won't take the location, if I set Legend with the concatenated field, it gives a different color to each State and I don't want that either, I want the coloration to go by the numerical values and I'm doing that with the Data Colors. And I want the Data Labels to be the numbers of the counts, I want them to show the same way as the state labels are showing in the attached image.
Thanks in advance!
Brenda
brendaivett the only way I can think of to do this would be to have some Lat and Long coordinates for each State
You can pick any in each state that plot well on the map you'll be using - see picture
(you may do this in a separate table so you only do it once for each state)
Then create your State Count COLUMN to use in the Location field
State Count COLUMN = 'Table'[State]&" - "&CALCULATE(SUM('Table'[Count]), ALLEXCEPT('Table', 'Table'[State]))
You can look at this post but I don't think it can be applied in your case
I was so looking forward to the ArcGIS Maps but we have even less flexibility there - for now.
I hope they add labels and tooltips soon.
Hope this helps! :smileyhappy:
This only works in certain scenarios but more often than not, I am unable to use the average of lat long because each bubble/point is unique and there are multiple points in the same area/state.
Microsoft should just add a way to select whichever field you want in the "Category labels", can't believe they still don't.
Hi,excellent solution, but i have a problem. How can I make the count consider the slicers that the report has?
Thank you very much!Thank you so much Sean! Your solution worked. Would you mind sharing your list of latitudes and longitudes?
I greatly appreciate your help!
Brenda