Skip to main content

Power BI

Planned

Conditional Formatting for Text

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

Mahindra Bisram on 05 Jul 2020 23:46:53

RE: Conditional Formatting for Text

I also need this functionality to format based on field value. For example, I need to format a field as follows :
Current=Green
Grace=Yellow
Expired=Orange
Closed=Red

Power BI User's profile image Profile Picture

Sancho Harker on 05 Jul 2020 23:46:46

RE: Conditional Formatting for Text

Wow, it's pretty ridiculous that this is not a feature.

It takes me less than 10 seconds to do this basic function in Excel, but Power BI ( an incredibly powerful BI tool) can't format based on text value of a field/cell?

All I want is to format all items where Cost="High" with a Red Background.

Power BI User's profile image Profile Picture

Chris Holloway on 05 Jul 2020 23:45:10

RE: Conditional Formatting for Text

It's a feature that seems so basic, but is surprisingly missing. I would agree with the others that we should be able to have conditional formatting based upon string matching.

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:44:30

RE: Conditional Formatting for Text

Based on text, and remove the aggregation (count and distinct count)

Power BI User's profile image Profile Picture

Mike Lonsdale on 05 Jul 2020 23:43:36

RE: Conditional Formatting for Text

'+1

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:43:20

RE: Conditional Formatting for Text

how many votes does this need to be implemented. Its embarrassing to tell customers that PBI can do all these amazing things, but can't do something as seemingly simple as text based formatting.,

Power BI User's profile image Profile Picture

michelle on 05 Jul 2020 23:43:04

RE: Conditional Formatting for Text

Please add conditional formatting based on text

Power BI User's profile image Profile Picture

Jaime Morton on 05 Jul 2020 23:42:39

RE: Conditional Formatting for Text

Yes this is really holding me back

Power BI User's profile image Profile Picture

Aaron Aslan on 05 Jul 2020 23:42:28

RE: Conditional Formatting for Text

'+1

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:42:20

RE: Conditional Formatting for Text

Add one more to the list

Merged Idea (2)