cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerBIGuy1 Frequent Visitor
Frequent Visitor

Conditional Formatting in Table Visualization

I am using latest Power BI desktop version (Version: 2.42.4611.901 64-bit (January 2017)).

 

I could not find conditional formatting option in Table Visualization. I can do regular formatting on row/column level. I found some forum threads and articles but they seems to be 3 months old etc. I wonder if conditional formatting is done differently or disappeared in latest version?

 

I want to color a value or change background of a cell, If a value is above 100 in a column.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Conditional Formatting in Table Visualization

I have the latest release and conditional formatting is there. You can add condition formatting on number columns (fields), make sure that is what you are doing.

 

format1.PNG






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





11 REPLIES 11
Super User
Super User

Re: Conditional Formatting in Table Visualization

I have the latest release and conditional formatting is there. You can add condition formatting on number columns (fields), make sure that is what you are doing.

 

format1.PNG






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





PowerBIGuy1 Frequent Visitor
Frequent Visitor

Re: Conditional Formatting in Table Visualization

I was trying it on a string column. But i think just having it on number column works for now.

Another scenario that I have is to color code a column value if we find certain keywords in a text column. Operators adds comment, We want to highlight some important comments based on URGENT keyword in the value. I figured out other ways to do it by finding it using a measured column and then color code based on measured column value etc.

Super User
Super User

Re: Conditional Formatting in Table Visualization

Awesome, it worked for you. Cheers!






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





medwards807 Regular Visitor
Regular Visitor

Re: Conditional Formatting in Table Visualization

In reguards to your post I had a similar issue I have an existing report where I have a text column in a Table Visual that has conditional filtering,  which still works however the option to change it is gone. Can you provide detail on how you addressed your highlight formatting for text?

AndrewDang Member
Member

Re: Conditional Formatting in Table Visualization

I am using the latest version of Power BI and I DON'T see the Conditional Format option. I am not sure what was wrong. I tried on all fields, incluidng text and number.

 

Could you please help.

 

Thanks;

Andrew

 

skareer Frequent Visitor
Frequent Visitor

Re: Conditional Formatting in Table Visualization

Hi! I came across your post and was wondering if you could share the way to color code a column value if we find certain keywords in a text column.You also discovered  other ways to do it by using a measured column and then color code based on measured column value etc. Could you please share how it works? Thank you!

Super User
Super User

Re: Conditional Formatting in Table Visualization

How I can help @skareer What is your question?






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





skareer Frequent Visitor
Frequent Visitor

Re: Conditional Formatting in Table Visualization

Is there a way I can conditionally format a column that has words? 

For eg: If I have yes or no as options then how can I put two different colors in the background of both cells that contain the options? 

Super User
Super User

Re: Conditional Formatting in Table Visualization

You cannot do conditional format on text fields. only option I can think of have two images (for yes and for no) and then add a new column with condition to select which image to use and use that column in your table. 

 

I hope it is helpful. Let me know if you need further help.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 111 members 1,572 guests
Please welcome our newest community members: