Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to 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
Have you tried setting your Minimum Value under Data Colors to -1?
Proud to give back to the community!
Thank You!
Negative, it didn't work out 😞
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
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
Proud to give back to the community!
Thank You!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |