Skip to main content
Microsoft Idea

Power BI

Planned

Conditional Formatting for Text

Vote (4599) Share
Power BI User's profile image

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 (151)
Power BI User's profile image Profile Picture

Tad Borowski on 06 Jul 2020 00:00:02

RE: Conditional Formatting for Text

Also need this.

Power BI User's profile image Profile Picture

John Neyer on 05 Jul 2020 23:59:37

RE: Conditional Formatting for Text

I know this isn't exactly what everyone is looking for, but conditional formatting by field may be a useful workaround - I've used it to format text fields in a table:

https://xxlbi.com/blog/conditional-formatting-by-field-value-in-power-bi/

Power BI User's profile image Profile Picture

Cristiano Souza on 05 Jul 2020 23:59:07

RE: Conditional Formatting for Text

It is quite required that PBI allows us to conditionally format fields based on their text values. That feature has been around for ~20 year now on Excel... Why not in PBI???

Power BI User's profile image Profile Picture

Gabriel Dojcak on 05 Jul 2020 23:58:54

RE: Conditional Formatting for Text

Just look at Qlik!! So simple.

Power BI User's profile image Profile Picture

Tobi Romero on 05 Jul 2020 23:58:00

RE: Conditional Formatting for Text

Please add this. It is sorely needed! +1 +1 +1 +1

Power BI User's profile image Profile Picture

apm on 05 Jul 2020 23:57:53

RE: Conditional Formatting for Text

bump

Power BI User's profile image Profile Picture

Scott Alt on 05 Jul 2020 23:57:39

RE: Conditional Formatting for Text

'+1

Power BI User's profile image Profile Picture

slarkin on 05 Jul 2020 23:57:39

RE: Conditional Formatting for Text

Great! Can't wait!

Power BI User's profile image Profile Picture

Christian Young on 05 Jul 2020 23:57:09

RE: Conditional Formatting for Text

'+1

Power BI User's profile image Profile Picture

Ali Wright on 05 Jul 2020 23:56:46

RE: Conditional Formatting for Text

August 2019 and still no further forward - it should be easy to add CF for text-based columns AND for CF in one column based on the text or number value in another. You've added icons - why not look at this, too?

Merged Idea (2)