Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
6 years ago
Solved

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...
Data Protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 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. 

Anonymous's avatar
Anonymous
Not applicable
6 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.