Card Visual Conditional Formatting

[Anonymous]

Thanks to all who respond.

I need help creating this measure:  I have 3 cards showing totals for 2021, 2020, 2019. I would like to have the font color change to red or green based on the previous year total. So if year 2020 amount was greater than 2021 change to 'red', if less than change to 'green'.

Table name = 'Sheet1'

Field name = 'Amount'

Field name = 'YEAR'

Any ideas?

Thanks-BLD

[KerKol · Accepted solution]

You'll need to use a different KPI Card visual. There are a few options in AppSource.

You could create your own card visual using Smart Narratives:

And change the colour of the font using this trick:

Smart Narratives and Conditional Formatting in Power BI? Yes please! - Guy in a Cube

[Anonymous]

Thank you, great idea.

BLD

[Anonymous]

@Anonymous HI, 

We cant dynamically change the font colour using Card, instaed use table for each value and you need to create 3 different measures where you need to use switch statement dax1 > dax2 then "Hex code of Red" like that..

Regards,
John Basha Mattipati,
https://www.linkedin.com/in/john-basha-mattipati-06812980/