Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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
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
This only changes the color of the font in one column, not the whole row.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |