Forum Discussion

abukapsoun's avatar
abukapsoun
Post Patron
9 years ago
Solved

Display zero value in filled map

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,

 

Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    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

4 Replies

  • fhill's avatar
    fhill
    Resident Rockstar
    9 years ago

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

      • fhill's avatar
        fhill
        Resident Rockstar
        9 years ago

        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