Forum Discussion
Conditional formatting for a text column
Hi PBI community, Is there a way to change the background or font color of a table cell for a text based column using DAX. Any help would be appreciated. Thank you!
I have found a solution which may help which I got help from one of my team members:
- Create a number value for the word by creating an additional column. For example 'Yes' as '1' and 'No' as '2'.
- Make sure the additonal column value is a whole number and not text.
- Apply and close
- Go to the field, use the drop down in the fields section and choose 'conditional formatting' - choose Background or Font colour.
- Choose 'Rules' for 'Format by'
- 'Summarization' as 'Minimum'
- Choose the number and the colour If value is '1' then 'Green'
- Click OK and it should work :)
This is a huge discovery for me. Thank you!!!