Table change row color depending on value

[lscoffield]

How do I change the font color of a row depending on the value of a column? Say if a column equals "changed" how do I make the row font color red? Is that even possible?

[simrantuli · Accepted solution]

Hi @lscoffield ,

Yes, it's very much possible.

Create a new measure.

Color = IF(Column= "Changed", "Give HEX Code of the color","Give HEX Code of the color that you want if the column is not "changed"').

And then use this measure under 'Conditional formatting'.

Enable 'Font Color'. A new dialog box will open.

Select 'Field value' under 'Format by' and select the newly created measure under 'Based on field'.

Regards

Simran Tuli

[SGVACG]

This only changes the color of the font in one column, not the whole row.

[mwegener]

Hi @lscoffield ,

look at this.

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