Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Changing Text Colours Based On Value

Hi, 

 

I have a data set which contains various columns that have "Yes" or "No" values. I have these columns displayed in a table and want the values to change colour.

 

If the value is "Yes" I want the text colour to change to Red

If the value is "No" I want the text colour to remain black

 

After browsing around on forums I have found the below Dax and have added it to the conditional format of each column but it is not working. Any ideas on how to achieve this?

 

Colour Change =
VAR Dept = SELECTEDVALUE('Safety Valve'[B A])
RETURN IF(Dept <> BLANK(), "Red", "Black")
 

Many thanks,

 

E

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi Anonymous ,

     

    Your Dax expression doesn't look right. For RED or GREEN color you will have to use HEX COLOR CODES. This is what Power BI understands as colours.

     

    Try creating a measure using following dax:

    Colour Change =
    VAR Dept = SELECTEDVALUE('Safety Valve'[B A])
    RETURN 
    SWITCH( TRUE(),
    Dept = "Yes", "#FF0000",
    Dept = "No", "#008000"
    )
     
    You this measure as an conditional formatting in your table visual on your column which has got values YES/NO. 
    You can change the hex color codes as per your requirement.
     
    Thanks,
    Pragati
     

2 Replies