Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to put conditional formatting on text ?

I have this table and I would like to put icons according to the state : 

 

Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    You could create a measure to use numbers to represent different states.

    Measyre =
SWITCH (
    SELECTEDVALUE ( 'table'[state] ),
    "Submitted", 1,
    "New", 2,
    "Rejected", 3,
    "Accepted", 4,
    "Closed", 5,
    "Planned", 6
)

    Then use the value of measure to create conditional formatting rule.

     

    Best Regards,

    Jay

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    You could create a measure to use numbers to represent different states.

    Measyre =
SWITCH (
    SELECTEDVALUE ( 'table'[state] ),
    "Submitted", 1,
    "New", 2,
    "Rejected", 3,
    "Accepted", 4,
    "Closed", 5,
    "Planned", 6
)

    Then use the value of measure to create conditional formatting rule.

     

    Best Regards,

    Jay

  • AnamPatel's avatar
    AnamPatel
    Resolver II
    4 years ago

    Click on the Down Arrow in front of the Column Name under Values Tab and Select Conditional Formatting > Icons

     

    A new Icon window will pop up – fill all the details, select the icon type you want and click on OK.

     

    That’s it, the icons will show up on your chart –