Skip to main content

Power BI

Planned

Conditional Formatting for Text

Vote (4703) 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 20 Jul 2024 20:49:20

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

Power BI User on 05 Jul 2020 23:26:56

RE: Conditional Formatting for Text

Neeeddd it. This is a low hanging fruit update for PBI, shouldn't be the hard

Power BI User's profile image Profile Picture

Carl Power BI User on 05 Jul 2020 23:26:54

RE: Conditional Formatting for Text

Formatting based upon text value comparisons would be very desired. Any ideas on when this might be implemented?

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:26:48

RE: Conditional Formatting for Text

It would be great to have conditional formatting based on text. For example, highlight (in colour) all product names, which contain a certain word

Power BI User's profile image Profile Picture

Josh Winn on 05 Jul 2020 23:25:59

RE: Conditional Formatting for Text

This would be great for formatting status text like Red, Yellow, Green.

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:25:33

RE: Conditional Formatting for Text

This is great. It would be great if "data bars" feature can be added as one of the conditional formatting option for text

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:25:33

RE: Conditional Formatting for Text

This is great. It would be awesome if "data bars" conditional formatting option is made available for text

Power BI User's profile image Profile Picture

AbhishekH on 05 Jul 2020 23:24:32

RE: Conditional Formatting for Text

Thanks Amanda,

Can we have a similar feature for Bar Charts?

Ability to highlight certain category labels on the x or y axis for bar chats using metrics.

Power BI User's profile image Profile Picture

anna on 05 Jul 2020 23:24:25

RE: Conditional Formatting for Text

need to be able to format on TEXT, ie Status, green = on track, red = behind

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:23:38

RE: Conditional Formatting for Text

Conditional formatting of text 'containing' X please!

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:23:37

RE: Conditional Formatting for Text

conditional formatting THE SAME as in excel

Merged Idea (2)