Display zero value in filled map

[abukapsoun]

Hi,

I have the following table,

South Africa   5

Nigeria           7 

Tanzania         0

I am using filled map, but Tanzania is not showing because it has zero value. Is there a way to still fill the zero value with the lightest color?

Thanks,

[fhill]

Have you tried setting your Minimum Value under Data Colors to -1?  

[abukapsoun]

Negative, it didn't work out 😞

[v-huizhn-msft · Accepted solution]

Hi @abukapsoun,

I use your sample table, it works fine as follows.

1. I set the address as country/region category.

2. Create filled map visual, select the Location field as Location level, the value as color saturation. Please review the expected result shown in screenshots below. The place with 0 shows correctly.



Best Regards,
Angelia

[fhill]

I wasn't able to duplciate you results using just the small sample you provided.  (My 0 did show up.)  Can you post a more complete sampleing of your data / measures?

FOrrest