Flag Red, Amber or Green in Card Visual

DAX DAX Calculations
1

I have a report whose home page is to flag up coloured values to monitor changes in relation to data. I have used Card visual in my report and it seems there is no way to using conditional formatting to accomplish the task. I’ll be glad if there is any other way to get the job done.

image
image1070×495 14.1 KB

File is attached
Target SettingA.pbix (963.8 KB)

Thank you

2

@upwardD ,

Yes, this is quite doable via conditional formatting. (I’ve just done the first card as an example).

  1. Create a SWITCH/TRUE measure similar to this one:

     CF Age Card = 

 SWITCH( TRUE(),
     [Average Age] >= 30, "Green",
     [Average Age] >= 20, "Gold",
     [Average Age] >= 13, "Red",
     BLANK()
 )

If you want more control over colors, you can use Hex codes instead of color names.

  1. Go to the properties for the card, go to Background, click on, and then hit the fx button

image

  1. Set the conditional formatting properties as follows:

image

and Boom! Conditionally-formatted cards.

image
image695×278 11.7 KB

I hope this is helpful. Full solution file posted below.

P.S. If you really want to go all out on this approach, you can also set up a second measure to conditionally format the card font, so say black if the background is between 20 and 20, or less than 13, white otherwise.

3 Likes