Forum Discussion
Conditional Formatting (Color Coding) based on a measure
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):
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.
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 :
for more detailed answers I need some Pbix files to work with.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 colorp.s. Setting the measure type as "Text" has helped in the past, but that no longer works for me now
4 Replies
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 :
for more detailed answers I need some Pbix files to work with.
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 colorp.s. Setting the measure type as "Text" has helped in the past, but that no longer works for me now
