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

b29012ec a5f7-4c0f-b041-a667682184e9 on 06 Jul 2020 00:14:37

RE: Conditional Formatting for Text

any update for this? Thanks

's profile image Profile Picture

a30bb224 18a4-4be5-92cd-507d672088f7 on 06 Jul 2020 00:14:33

RE: Conditional Formatting for Text

Come on PBI, get this over the line! We need to be able to easily conditional format text like in Excel. IF the value is Yes, the colour text green etc.

's profile image Profile Picture

a5a4ef75 d4f4-e811-a956-000d3a4f36ce on 06 Jul 2020 00:13:02

RE: Conditional Formatting for Text

Not quite two years since the official Microsoft response... any update?

's profile image Profile Picture

76ebaf25 576f-4d72-b84d-2cd1415b93e7 on 06 Jul 2020 00:12:24

RE: Conditional Formatting for Text

Have tables that have rankings with high medium and low would love to color code these in te the table

's profile image Profile Picture

7d4113f9 2033-4421-bbd9-f91e672de6be on 06 Jul 2020 00:10:38

RE: Conditional Formatting for Text

This feature is very welcomed to highlight status informations like on track etc.
conditional format on field content is very helpful.

Please improve PowerBi by this function - since May 2018 its planned....

's profile image Profile Picture

b814a689 50bd-4f86-90ab-37437724959c on 06 Jul 2020 00:10:35

RE: Conditional Formatting for Text

Please add this soon!

's profile image Profile Picture

d5fd7c61 fb16-4920-903c-8d81e8521e1e on 06 Jul 2020 00:09:21

RE: Conditional Formatting for Text

Looking forward to this new feature :-)

's profile image Profile Picture

183117aa 9fd3-4a0f-8d4f-3d62c9ccb68e on 06 Jul 2020 00:09:12

RE: Conditional Formatting for Text

Yes we need this feature too! Don't forget boolean fields (True, False), so that such columns could also be formatted based on the boolean value!

's profile image Profile Picture

340eb602 bc4e-4b53-b24d-86b814bd0c74 on 06 Jul 2020 00:09:01

RE: Conditional Formatting for Text

Please, we need it!

's profile image Profile Picture

6ec45873 7d59-433a-8b21-b87b1e75cc6c on 06 Jul 2020 00:08:56

RE: Conditional Formatting for Text

PLEASE ADD THIS!