Forum Discussion
Conditional Formatting Error with Shape Map
Hello community,
I am having an issue when I am using conditional formatting for the colors on a shape map.
I am using a measure (Utilization %) to determine the state's color (map of U.S.). The "Utilization %" measure finds the customer transactions with a certain label, and divides it by the total number of transactions. The map colors are where the Utilization % fits into a category: Green (90% or greater), Yellow (70 - 90%), and Red (under 70%).
However, certain states' tooltip is showing 92%, but will display yellow. Or 88% and green. There are no filters being applied to the calculation, but using a dimension table to filter the states can cause some of them to change color. I think something weird is happening in the filter context.
Any help would be appreciated, thanks!
- Anonymous4 years ago
Thanks, but I figured it out. I put the rules in as a decimal, not a percentage. For some reason PowerBI got messed up from it.
2 Replies
- HotChilliCommunity Champion
If you provide a sample pbix I'll have a look at it
- AnonymousNot applicable
Thanks, but I figured it out. I put the rules in as a decimal, not a percentage. For some reason PowerBI got messed up from it.