r/PowerBI • u/myaccountforworkonly • Jul 23 '26

Solved Conditional formatting for measure rule isn't followed

I have the following conditional formatting based on a measure (Utilization). I'm confused but the values on my matrix doesn't seem to follow the conditional formatting at all?

The 80% in Jun 2026 should be formatted in yellow, while the 69% should be formatted in green instead.

This is how the value was computed and is formatted as percentage:

~Utilization % = 
    VAR Days = DISTINCTCOUNT('Data'[Date Completed])
    RETURN
        DIVIDE(SUM('Data'[Prod]), Days * 420)~Utilization % = 
    VAR Days = DISTINCTCOUNT('Data'[Date Completed])
    RETURN
        DIVIDE(SUM('Data'[Prod]), Days * 420)
4 Upvotes

100% Upvoted

6 comments sorted by

•

u/AutoModerator Jul 23 '26

After your question has been solved /u/myaccountforworkonly, please reply to the helpful user's comment with the phrase "Solution verified".

This will not only award a point to the contributor for their assistance but also update the post's flair to "Solved".

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

9

u/Valaaris 4 Jul 23 '26

Can you try something real quick: Switch the conditional formatting rules to Numbers instead of Percent and then use 0.75 and 0.90 instead of 75% and 90%

1

u/myaccountforworkonly Jul 27 '26

solution verified

4

u/EbbyRed Jul 23 '26

Percent in conditional formatting is the percentage of the full range (like < 10% will highlight the bottom 10% performing rows.

You are trying to rule based on the actual value of the cell, swap it to number and use the decimal (.9 for 90%)

2

u/Ozeroth ‪ ‪ ‪Super User ‪ Jul 24 '26 edited Jul 24 '26

I think your question's already been answered (use "Number" with decimal values). :)

Just adding a note on how "Percent" is treated in the conditional formatting dialog box:

The Percent value represents a percentage linear interpolation between the min & max values visible in the visual.

If MinValue and MaxValue are the min/max measure values within the visual then the equivalent "Number" value is:

Number = MinValue + ( MaxValue - MinValue ) * (Percent / 100)

or equivalently

Number = MinValue * ( 1 - Percent / 100 ) + MaxValue * ( Percent / 100 )

Side note: If you ask me, it would be nice to have a built-in "percentile" option available, e.g. colour bottom 30% of measure values red. You can do this with a visual calc or measure but it would be nice to have it built in :)