Power BI

Planned

Conditional Formatting for Text

Vote (2910)

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 09 May 2018 06:00:57

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

Comments (133)

b13608fb 31ec-4462-9032-1199a0143dd0 on 05 Jul 2020 23:29:30

RE: Conditional Formatting for Text

Get errr done :)

ce0a01a8 b0d4-48da-a032-399d111b4404 on 05 Jul 2020 23:29:10

RE: Conditional Formatting for Text

Hi Amanda, how is it going with the feature to conditionally format based on text input?

f2bc4024 45f1-481a-b573-922bcd22f23b on 05 Jul 2020 23:29:03

RE: Conditional Formatting for Text

Hello,

I would also like to know when this item will be updated.

eb4d6a10 946b-4a92-b74f-4dbc9e332a96 on 05 Jul 2020 23:28:58

RE: Conditional Formatting for Text

Hi, What is the status of this feature? When are you planning to release this? Thanks :)

69169d1b 92c2-4ed5-85ec-d30fe68a2554 on 05 Jul 2020 23:27:27

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.