Condition Formatting: Text Background Colour

[HenryJS]

Hi all,

I have a text column created using DAX.

How can I choose background colours for this text field in the matrix in the bottom picture?

From what I can see the 'Rules' conditional formating option needs numerals..

[Mariusz]

Hi @HenryJS 

You can create a Measure that will assign a number to every text string using the SWITCH function, later use this Measure for conditional formating.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous · Accepted solution]

Hi @HenryJS,

You can create a measure that is used in conditional formatting "Field Value".

The General Measure would look like this: Measure = SWITCH(Selectedvalue([Status]),"Missing","red","Saved", "#90ee90")
You can put all the Values in and determine the color based on "color" or you input a HEX color.

Hope it helps,

Kind regards
Joren Venema

Data & Analytics Consultant
If this reply solved your question be sure to mark this post as the solution to help others find the answer more easily.