Skip to main content
Microsoft Idea

Power BI

Planned

Conditional Formatting for Text

Vote (4655) 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 (153)
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?

Power BI User's profile image Profile Picture

Sainath on 05 Jul 2020 23:56:10

RE: Conditional Formatting for Text

'+1

Power BI User's profile image Profile Picture

Henrique Lopes on 05 Jul 2020 23:55:42

RE: Conditional Formatting for Text

Up Up Up

Power BI User's profile image Profile Picture

Roberto Risseeuw Gilchrist on 05 Jul 2020 23:54:46

RE: Conditional Formatting for Text

'+1

Power BI User's profile image Profile Picture

Anonymous on 05 Jul 2020 23:54:12

RE: Conditional Formatting for Text

Another basic feature missing from Power BI...

Power BI User's profile image Profile Picture

Janet Walker on 05 Jul 2020 23:51:40

RE: Conditional Formatting for Text

Please please please add ability to do conditional formatting based on actual text! Would make data cards so much more powerful if I could change font or background color to stand out based on word displayed. For example "Go" would be in GREEN, "No Go" would be in RED

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:51:21

RE: Conditional Formatting for Text

It would be great if the expansion of this feature allowed for DAX statements as this would really open up the functionality

Power BI User's profile image Profile Picture

John LaGrange on 05 Jul 2020 23:51:07

RE: Conditional Formatting for Text

'+1 to conditional formating

Power BI User's profile image Profile Picture

jacob on 05 Jul 2020 23:50:31

RE: Conditional Formatting for Text

Really unfortunate this is not possible. Would be extremely easy to do in a DAX if statement. Please add

Merged Idea (2)