Power BI

Planned

Conditional Formatting for Text

Vote (4660)

Power BI User on 09 Nov 2017 03:18:20

It would be great to conditional format a table and/or a matrix based on the cell text, not only numbers

Administrator on 03 Aug 2022 05:06:29

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.

Comments (154)

David Benaim on 05 Jul 2020 23:18:39

RE: Conditional Formatting for Text

This is coming in May I was told :)

Carlos Herrera on 05 Jul 2020 23:18:32

RE: Conditional Formatting for Text

A basic feature is to be able to compare vs. a measures or table values, not just hardcoded values on the rule.

Power BI User on 05 Jul 2020 23:18:22

RE: Conditional Formatting for Text

'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).

Paul on 05 Jul 2020 23:17:50

RE: Conditional Formatting for Text

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.