Power BI

Planned

Conditional Formatting for Text

Vote (4647)

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 (151)

Snehal Mule on 25 Jul 2023 09:23:06

RE: Conditional Formatting for Text

Can you please let us know tentative date or Plan to implement this feature ?

Sako Kassabian on 14 Mar 2023 23:01:18

RE: Conditional Formatting for Text

PLEASE PLEASE PLEASE

as others have said, we NEED bold, italic, etc as part of conditions. I'm about to present a project and I'm unable to bold some row headers and I'm going to be asked for that 'simple' change and my answer will be, 'sorry, not possible'. It looks bad on the product.

Jacek Pawlowski on 21 Feb 2023 10:55:16

RE: Conditional Formatting for Text

really happy with this addition, thank you

just a thought though, I'm a big fan of the 'Fields Parameter' feature that was introduced recently, very helpful feature.

Would you consider an enhancement of the string conditional formatting, just so it works with columns based on the Fields Parameter' value? It would be a fantastic addition to this I think.

Thanks :)

Jonathan Stephen on 07 Feb 2023 14:57:26

RE: Conditional Formatting for Text

No Brainer, simple excel style Text Value Conditional Formating without having to a) create a measure and b) write Code

Come on this utterly ridiculous

Kyle Smith on 21 Jul 2022 14:18:42

RE: Conditional Formatting for Text

It is a bit frustrating sometimes to see this still not being added yet they take the time to add Augmented Reality Support for Dashboards when it feels like that feature would have a single digit percentage of utilisation (or lower) from the Power BI userbase.

The functionality's in Excel, why is this still not being added to Power BI?

Jillian Kratish on 26 Jun 2022 22:14:57

RE: Conditional Formatting for Text

Would also love to have bold, italic, underline, etc options for specific column. (Or specific row if using a matrix visual). Not necessarily conditional formatting.

But speaking of conditional formatting, I sometimes want to have conditional formatting across several columns, not just one. If I have 5 different expense streams in a visual, I'd love to be able to color scale the whole values area.