Auto change a card background colour depending on text within

[seancearnaigh]

Hi Folks,

From a Project Management perspective, i want to show the rag status of a project as red, green, amber. Now we have more than one project on the go so as opposed to manually going in and changing the background coulour of all projects, is there any custom visual that can check if status = GREEN, change background colour to green, same for Amber / Red ??

I know there is one based on values (Card with states) but not text from what i have seen so far??

Any thoughts?

[Seth_C_Bauer · Accepted solution]

@seancearnaigh You can do this with a combination of DAX function and layering. @SqlJason wrote up a good blog around this awhile ago. You can check it out here

[seancearnaigh]

thank you for that info - really appreciate it

[Anonymous]

@seancearnaigh : Where you able to achieve this? If yes, could you please shed some light? 

[seancearnaigh]

Yes - We had a  field called rag status which contained Red - Amber - Green. I created another numeric field to correspond to these -> 0 -1 - 2

Then go into your report - edit it - Go into Conditional Format - select the field you want to colour to appear on - Turn on Background Colour and hit Advanced Controls - Format by Rules - select the new field with the numeric values (0-1-2) within the 'Based on Field' drop down - Then just add your rules accordingly.

Note, there may be an easier way to do above but it worked for me!

[Anonymous]

Hi @seancearnaigh : What you are saying can be achieve by using a table not a card, right?