Forum Discussion
Change card color dynamically using measures
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
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.
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
thank you case resolved.