After i have highlight the certain column text to ted , may i know how to remove it ?

[admin11]

Hi All

I have using the below expression for highlight certain column text to red :-

COLOUR ROW = if(max(Format_PnL[Index]) in {14,33,35,52,73,84,99}, "red", "white")

May i know how to remove the condition setting , so that all text become black colour .

https://www.dropbox.com/s/4fyd0m3uooxjbmx/GL_WORKING%20v015.pbix?dl=0

above link is my PBI file.

Paul

[Anonymous · Accepted solution]

Click on Sub category dropdown from fields in visualization pane.

Click on Remove COnditional formatting to make all black.

Attached is the file.

[Rigensis]

@admin11 Click on the table > go to Conditional formatting > select the column on which you have applied the formatting, in your case 'Sub Category' > turn the slider for the conditional formatting to the off position