Forum Discussion
msalamon
Helper I
Helper IShape Map Areas with No Data
I have added a shape map of the US to track information for every state. For example (and for fun), imagine that I am tracking the number of UFO sightings per state, and in other visualizations on t...
msalamon See attached.
Greg_Deckler
Community Champion
Community Championmsalamon I didn't forget about you! OK, the way to fix this is to add a row in for all states. Then you can do a little DAX magic to end up with 0 for states that have no sightings. Take a look, this isn't great because I had to do some work-a-rounds because I didn't have your excel file. I would use Table (2) and Merge it with your original table to create a new table with the missing states and go from there but hope you get the idea. You want Page 2 of attached PBIX below sig.
msalamonGreg_Deckler Thanks! I will take a look at this.
Btw, here is the original excel file: https://drive.google.com/file/d/1OJiP8O1_7GfTaoBUEsHIreoeZvpoe49Z/view?usp=sharing
- Greg_Deckler
msalamon No access
- msalamon
Greg_Deckler try again?