Change card color dynamically using measures

[Satz27]

I have a case related to text coloring based on predefined conditions (<95% green, 95-99% yellow, > 100% red). currently I use the color feature in the data label, but the colors that appear do not match, some are >100% red, some are green.

the following measures I use :

IF(SELECTEDVALUE('2  Operation Metrics'[Operational Metrics]) = "Productivity",
IF(SELECTEDVALUE('2  Operation Metrics'[Product]) = "Gondorukem",
IFERROR("(" &ROUND(100*([_OM_Actual]/[_OM_Target]),0)& "% Target)", "N/A"),
IFERROR("(" &ROUND(100*([_OM_Actual_Average]/[_OM_Target_Ach]),0)& "% Target)","N/A")),
IFERROR("(" &ROUND(100*([_OM_Actual_Average]/[_OM_Target_Ach]),0)& "% Target)","N/A"))

I want to create conditions using measures not using color labels, can anyone help me with what steps?

[themistoklis · Accepted solution]

@Satz27 

Maybe this topic will help you:

https://community.powerbi.com/t5/Desktop/dynamic-rule-for-changing-color-of-a-measure/m-p/1100128

[themistoklis · Accepted solution]

@Satz27 

Maybe this topic will help you:

https://community.powerbi.com/t5/Desktop/dynamic-rule-for-changing-color-of-a-measure/m-p/1100128

[Satz27]

I tried but the result that appears error x

measures _OM_YTDSnapshotRendemen :

IF(SELECTEDVALUE('2  Operation Metrics'[Operational Metrics]) = "Productivity",
IF(SELECTEDVALUE('2  Operation Metrics'[Product]) = "Gondorukem",
IFERROR("(" &ROUND(100*([_OM_Actual]/[_OM_Target]),0)& "% Target)", "N/A"),
IFERROR("(" &ROUND(100*([_OM_Actual_Average]/[_OM_Target_Ach]),0)& "% Target)","N/A")),
IFERROR("(" &ROUND(100*([_OM_Actual_Average]/[_OM_Target_Ach]),0)& "% Target)","N/A"))

[themistoklis]

@Satz27 

It seems that the measure _OM_YTDSnapshotRendemen doesnt return a number but a text. Is that correct?

Try to wrap this measure in a VALUE function. Like below:

VALUE([_OM_YTDSnapshotRendemen])>100, "Red"

[Satz27]

for the number it's not text but I added punctuation text () & and Target text, I've temporarily deleted () & and Target but what comes out is not a colored number but text as I screenshot.

[themistoklis · Accepted solution]

@Satz27 

This measure with the colours that you created must be used in conditional formatting not in the values section of the visual.

So, add a card visual (if this is the visual that you use)

Add the metric _OM_YTDSnapshotRendemen to this visual

Now go to format options of the visual --> Click on Data Label --> then fx

Format by: Field

Select the new measure field that you created with the color formula

[Satz27]

thank you case resolved.