Forum Discussion
HenryJS
6 years agoPost Prodigy
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 fo...
- Anonymous6 years ago
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.
Mariusz
6 years agoCommunity Champion
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
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.