Conditional Formatting for Text
It would be great to conditional format a table and/or a matrix based on the cell text, not only numbers
This month we added the ability to format text fields based off a numeric field: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#conditionalFormatting
We also are planning on adding a feature that will let you format your text based on comparisons. I’ll update this idea based on our progress on that feature.
David Benaim commented
This is coming in May I was told :)
Carlos Herrera commented
A basic feature is to be able to compare vs. a measures or table values, not just hardcoded values on the rule.
Two very important things for me:
- Highlighting the whole row in a table based on single measure.
- Highlighting the whole row in a table based on dimension in the table (for example: paint each department in its own color).
I am surprised conditional formatting only seems to apply to numbers; it needs to be applicable to text.
Also, whilst it does apply for numbers it doesn't seem to be extendable to total rows which is highly inconvenient too.
This is pretty basic functionality. How are we supposed to drill through the big reports without proper visuals?
A basic function in reporting to be able to change color if value >,<,= limit, and to pick the limit from data source too
I really need this so I can display red, amber, green status for project reporting
Amit Ganguli commented
Please have this added ASAP.
Vincent Pray commented
Have wanted this for so long! PBI dev - check out Dev Express for conditional formatting ideas - best functionality for this I've ever seen.
Sara Mesquita commented
Really important! It is a basic need ...
This seems pretty basic. Should have been done by now.
I totally Agree with this; It would be great to conditional format a table and/or a matrix based on the cell text, not only numbers.
Also, it would be nice to be able to have a full row to be conditional formatted based on a value from a specific column too!
lack of this functionality make the use of Power BI completely useless as a project and program BI tool, we were considering its use however is back to excel and the current PPM tool
and not only from cells text, we need the posibility to select a value from query or table
Agreed. This seems well overdue for this product.
Unbelievable this is not yet possible. We try to switch our users to PowerBI from our legacy reporting tool but with lot of functionality we have to tell them... its not (yet) possible. It feels like going backwards.
James Midgley commented
The ability to conditionally format text in a table is more important than supporting this for numbers. I find it inexplicable that you would release such a half baked feature particularly when this is something so easily achieved in Excel.
Tom Hawthorn commented
Imagine a matrix with rows representing some list of systems, and a column which displays pass/fail or perhaps operational/non-operational. I want to show good rows as green, bad rows as red. One simple way to do this would be to allow conditional formatting for a cell on any value in the row, even values that aren't displayed. I could create a calculated column which is a number like zero or one. Then I could format "pass" as green if the hidden value is 1, or red for 0.
Alison Wright commented
This is essential for me as a data analyst in a school where we use alphanumeric grades. In a matrix I am limited to conditional formatting only if all values in the matrix are numbers - seems crazy. I\d like to be able to conditionally format values in one field based on the value in another