Skip to main content

Power BI

Planned

Conditional Formatting for Text

Vote (2910) Share
's profile image

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

ee501f99 71a2-4f25-9e8d-d9d2d5fed968 on 06 Jul 2020 00:08:31

RE: Conditional Formatting for Text

I would love the ability to colour format text fields based on their content - "live policy = green, cancelled policy = red".
Please add this feature !!

's profile image Profile Picture

13228f8b 8ff3-46be-b061-b68e685fd210 on 06 Jul 2020 00:08:21

RE: Conditional Formatting for Text

Just add it already

's profile image Profile Picture

30ca1a57 8315-49ff-81f2-4962fabf5209 on 06 Jul 2020 00:08:21

RE: Conditional Formatting for Text

Any update on conditional formatting for text?

's profile image Profile Picture

fdb68c1a 5096-45f2-a3af-f5839a5a7560 on 06 Jul 2020 00:08:14

RE: Conditional Formatting for Text

Please add this feature, this probably should have been a given especially since it's been planned for 2 years. Please!

's profile image Profile Picture

79d981f8 bb4f-4b50-ae5d-6dc04645f8af on 06 Jul 2020 00:07:57

RE: Conditional Formatting for Text

Please can you get this one delivered? Our users are used to having this functionality in other data visualisation tools, so not having it is exactly the sort of thing that makes colleagues challenge us moving to Power BI.

's profile image Profile Picture

37490729 bbb2-4906-8e60-54cf9f95a960 on 06 Jul 2020 00:07:56

RE: Conditional Formatting for Text

Please add this feature as makes visualisation of issues a lot easier

's profile image Profile Picture

e982d8da 3c2a-406b-85b7-b7fe20aa1ffc on 06 Jul 2020 00:07:13

RE: Conditional Formatting for Text

Please update. Tableau has had this functionality for years. I really saddens me that Power BI doesn't have this capability yet. Please prioritize.

's profile image Profile Picture

271b5d21 adab-4b0b-8511-26c665969a07 on 06 Jul 2020 00:06:50

RE: Conditional Formatting for Text

This is badly needed... I need to have a table cell turn green if true and red if false. It looks like you have everything in place already, not sure why simple text value match is not already in the software.

's profile image Profile Picture

5e97ac6b bec6-40e9-b143-e64281622436 on 06 Jul 2020 00:06:33

RE: Conditional Formatting for Text

Any updates on this?

's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 06 Jul 2020 00:04:57

RE: Conditional Formatting for Text

Planned since May, 2018?