Forum Discussion

abukapsoun's avatar
abukapsoun
Icon for Post Patron rankPost 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 sti...
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

fhill's avatar
fhill
Icon for Resident Rockstar rankResident Rockstar
9 years ago

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

  • abukapsoun's avatar
    abukapsoun
    Icon for Post Patron rankPost Patron
    9 years ago

    Negative, it didn't work out :(

    • fhill's avatar
      fhill
      Icon for Resident Rockstar rankResident 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

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      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