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:
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,excellent solution, but i have a problem. How can I make the count consider the slicers that the report has?
Thank you very much!