Forum Discussion
Auto change a card background colour depending on text within
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 : Where you able to achieve this? If yes, could you please shed some light?
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!
Hi seancearnaigh : What you are saying can be achieve by using a table not a card, right?