Conditional formatting for values apparing through DAX logic and visualised in card visual.

[Prash546]

I have created a DAX logic for getting values based on few logic to measure a metric, where my final result appears both in amounts and percentage and later I bring it this over to a card visual like 'Value above $XXX,XX & YY%' and it appears in black font, is there a way I can format in conditionally so that when it is negative I can make it appear in red and if it is positive it appears in green.

[v-gizhi-msft · Accepted solution]

Hi,

You can set Card visual->Format->Data Label->conditional formatting.

I create a simple sample to show.

Create a color measure to check:

Color = IF(SUM('Table'[Value])>20,"#FF0000","#00FF00")

Apply this measure to the Card visual:

And it shows:

Hope this helps.

Best Regards,

Giotto Zhi

[VasTg]

@Prash546 

Select the card visual. Under the data label, on the right cornor, you would see three dots(eclipse icon). When you click, you would see conditional formatting.

You could set the color based on Rules..

If it helps, mark it as a solution

Kudos are nice too