Table visual color font if contains text

[tnad]

Hi,

I'm new to power bi. For the table visual, any step-by-step info on how I can color cell font if it contains the text "Note" for example? Thanks.

[amitchandak]

@tnad , refer

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

https://www.youtube.com/watch?v=MAISRa88bl0

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

[AllisonKennedy · Accepted solution]

See this link: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#:~:tex....

So basically, you need to create a Measure or Column that has a color name or numerical value that you can use to format the font color.

Try using
FormatColumn= IF(CONTAINSSTRING(Table[Column], "Note"), 1, 0)

Then use the link I provided above to apply conditional formatting for the FormatColumn when value >0.