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:22:16

RE: Conditional Formatting for Text

Great! Cant wait to have it!

Power BI User's profile image Profile Picture

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

RE: Conditional Formatting for Text

Great! Cant wait! Lets just have the option to say IF State = 'Washington' Color it 'Green' IF State = 'Arizona' then color the text cell Orange.

Power BI User's profile image Profile Picture

Stephen on 05 Jul 2020 23:22:02

RE: Conditional Formatting for Text

Thank god.

Power BI User's profile image Profile Picture

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

RE: Conditional Formatting for Text

Woo Hoo conditional formatting on text!

Power BI User's profile image Profile Picture

Erin Bookey on 05 Jul 2020 23:19:13

RE: Conditional Formatting for Text

Unfortunately, this new ability doesn't solve the problem as in order to get text formatting I would have to create a bogus measure and have that show up in the table in order to get formatting on the important item which is text.

Power BI User's profile image Profile Picture

Kawabata Yoshihiro on 05 Jul 2020 23:19:13

RE: Conditional Formatting for Text

Happy "PLANNED" status for conditional formatting Text.

Power BI User's profile image Profile Picture

Jesus on 05 Jul 2020 23:19:04

RE: Conditional Formatting for Text

When is able to compare versus another value from datasource or at least one other column in the same table? all people need this upgrade

Power BI User's profile image Profile Picture

David Benaim on 05 Jul 2020 23:18:39

RE: Conditional Formatting for Text

This is coming in May I was told :)

Power BI User's profile image Profile Picture

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's profile image Profile Picture

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

Merged Idea (2)