Forum Discussion
Shape Map Areas with No Data
msalamon See attached.
msalamon 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.
Greg_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
msalamon No access
Greg_Deckler try again?
msalamon Yep, was able to download, do you want me to give this a shot again using your Excel file or did my previous PBIX work out enough for you?