Skip to main content

Power BI

Planned

Conditional Formatting for Text

Vote (4701) 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

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

Power BI User's profile image Profile Picture

Paul on 05 Jul 2020 23:17:50

RE: Conditional Formatting for Text

I am surprised conditional formatting only seems to apply to numbers; it needs to be applicable to text.

Also, whilst it does apply for numbers it doesn't seem to be extendable to total rows which is highly inconvenient too.

Power BI User's profile image Profile Picture

Shital on 05 Jul 2020 23:17:47

RE: Conditional Formatting for Text

This is pretty basic functionality. How are we supposed to drill through the big reports without proper visuals?

Power BI User's profile image Profile Picture

Mats on 05 Jul 2020 23:17:46

RE: Conditional Formatting for Text

A basic function in reporting to be able to change color if value >,

Power BI User's profile image Profile Picture

Chris on 05 Jul 2020 23:17:35

RE: Conditional Formatting for Text

I really need this so I can display red, amber, green status for project reporting

Power BI User's profile image Profile Picture

Amit Ganguli on 05 Jul 2020 23:17:22

RE: Conditional Formatting for Text

Please have this added ASAP.

Power BI User's profile image Profile Picture

Vincent Pray on 05 Jul 2020 23:16:33

RE: Conditional Formatting for Text

Have wanted this for so long! PBI dev - check out Dev Express for conditional formatting ideas - best functionality for this I've ever seen.

Power BI User's profile image Profile Picture

Sara Mesquita on 05 Jul 2020 23:16:33

RE: Conditional Formatting for Text

Really important! It is a basic need ...

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:16:27

RE: Conditional Formatting for Text

This seems pretty basic. Should have been done by now.

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:16:15

RE: Conditional Formatting for Text

I totally Agree with this; It would be great to conditional format a table and/or a matrix based on the cell text, not only numbers.

Also, it would be nice to be able to have a full row to be conditional formatted based on a value from a specific column too!

Merged Idea (2)