cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
admin11
Post Prodigy
Post Prodigy

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

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")

admin11_0-1613489247066.png

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

 

1 ACCEPTED SOLUTION
NikhilKumar
Super User II
Super User II

Click on Sub category dropdown from fields in visualization pane.

Click on Remove COnditional formatting to make all black.

NikhilKumar_0-1613491067083.png

 

 

Attached is the file.


Nikhil
Hit the Thumbs-up button if you find this informative!!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!

View solution in original post

2 REPLIES 2
NikhilKumar
Super User II
Super User II

Click on Sub category dropdown from fields in visualization pane.

Click on Remove COnditional formatting to make all black.

NikhilKumar_0-1613491067083.png

 

 

Attached is the file.


Nikhil
Hit the Thumbs-up button if you find this informative!!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!

View solution in original post

Rigensis
Helper I
Helper I

@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

Rigensis_0-1613490843842.png

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.