Forum Discussion
Condition Formatting: Text Background Colour
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..
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.
2 Replies
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.
