Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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! 



  • Anonymous's avatar
    Anonymous
    4 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

    • Anonymous's avatar
      Anonymous
      Not 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.