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.
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.
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?
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!
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 Feel free to email me with any of your BI needs.