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 (153)
- Merged Idea (2)
RE: Conditional Formatting for Text
Would be great to be able to colour a text column based on the text it contains. E.g. Simple Yes/No column which you could colour "Yes" in green and "No" in red.
The conditional formatting options feel quite limiting in comparison to Excel's options. My clients are still blown away by all the amazing features they have available on their reports but baffled by the fact that I have to provide some of the reports in an Excel document because Power BI is not capable of displaying the information in the way they wish to see it.
RE: Conditional Formatting for Text
Having this would be amazing!
RE: Conditional Formatting for Text
Neeeddd it. This is a low hanging fruit update for PBI, shouldn't be the hard
RE: Conditional Formatting for Text
Formatting based upon text value comparisons would be very desired. Any ideas on when this might be implemented?
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
RE: Conditional Formatting for Text
This would be great for formatting status text like Red, Yellow, Green.
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
RE: Conditional Formatting for Text
This is great. It would be awesome if "data bars" conditional formatting option is made available for text
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.
RE: Conditional Formatting for Text
need to be able to format on TEXT, ie Status, green = on track, red = behind