Forum Discussion
Change card color dynamically using measures
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?
Maybe this topic will help you:
https://community.powerbi.com/t5/Desktop/dynamic-rule-for-changing-color-of-a-measure/m-p/1100128
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
6 Replies
Maybe this topic will help you:
https://community.powerbi.com/t5/Desktop/dynamic-rule-for-changing-color-of-a-measure/m-p/1100128
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"))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"
