Conditional Formatting (Color Coding) based on a measure

[ranghel]

Hello,

I'm trying to color-code the values in the matrix based on a measure that I created. Basically, if the value falls within the range of the measure (Calibration Range at the top) have a green background color, otherwise orange. I've been at it for days and still can figure it out. 

This is the formula for my measure (data type - Decimal number):

Calibration Range = FIXED((AssessmentHistory[Assessment Score]-(5)),2,1) & "%" & "-" & FIXED((AssessmentHistory[Assessment Score]+(5)),2,1) & "%"

Moreover, the option to format style based on the Field value is not allowing me to pick a field.

Thank you in advance for your time.

[Ritaf1983 · Accepted solution]

Hi @ranghel  you can create a dynamic measure for it based on your condition that will retunt true o false.

please refer to my answer including the sample file here :

https://community.fabric.microsoft.com/t5/Desktop/Conditional-formatting-with-measure-as-rule/m-p/33...

for more detailed answers I need some Pbix files to work with.

[technolog · Accepted solution]

You can fix it in 3 steps:

1. Set one color in the measure without any conditions

2. Set this measure for visualization
3. Set the right condition in the measure to calculate the color

p.s. Setting the measure type as "Text" has helped in the past, but that no longer works for me now

[Ritaf1983]

Hi @ranghel 
To format by measure try to select "rules "

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[ranghel]

Thank you @Ritaf1983. Unfortunately, it doesn't work because I don't have a fixed value to use in the rule. My values always change based on my slicer selection. 

[Ritaf1983 · Accepted solution]

Hi @ranghel  you can create a dynamic measure for it based on your condition that will retunt true o false.

please refer to my answer including the sample file here :

https://community.fabric.microsoft.com/t5/Desktop/Conditional-formatting-with-measure-as-rule/m-p/33...

for more detailed answers I need some Pbix files to work with.