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

a9af75ce 246b-4c56-89e6-a80df0a0178f on 05 Jul 2020 23:43:20

RE: Conditional Formatting for Text

how many votes does this need to be implemented. Its embarrassing to tell customers that PBI can do all these amazing things, but can't do something as seemingly simple as text based formatting.,

's profile image Profile Picture

205afa0e fe60-448d-86d0-62235ee72ca4 on 05 Jul 2020 23:43:04

RE: Conditional Formatting for Text

Please add conditional formatting based on text

's profile image Profile Picture

03352a50 a502-447f-a038-4017fd1ec71b on 05 Jul 2020 23:42:39

RE: Conditional Formatting for Text

Yes this is really holding me back

's profile image Profile Picture

5e2c44cd e942-4bf9-b49a-d6d792d05450 on 05 Jul 2020 23:42:28

RE: Conditional Formatting for Text

'+1

's profile image Profile Picture

f43900a7 84c2-4bd0-87c6-1738e2887740 on 05 Jul 2020 23:42:20

RE: Conditional Formatting for Text

Add one more to the list

's profile image Profile Picture

662ebb25 a64d-451a-87e8-a973cf8a26e6 on 05 Jul 2020 23:42:20

RE: Conditional Formatting for Text

yes please !!!

's profile image Profile Picture

fd36975e 8f0f-4405-a7bd-f41f735f505d on 05 Jul 2020 23:41:22

RE: Conditional Formatting for Text

I hope this feature will be added on the next update/release this will greatly help our customization of our dashboards!

's profile image Profile Picture

d50af593 3d1c-45de-a4e3-4d8e18351163 on 05 Jul 2020 23:40:54

RE: Conditional Formatting for Text

As of February 12 2019 I still cannot conditional format for text, even though I changed the data type of the column to "Text". This is a feature I often used in excel to compare mismatching columns, text that started with XYZ or contained XYZ.

Why does Power Bi insist on turning all my text columns into "Count"? So frustrating.

's profile image Profile Picture

20935d70 e2fe-4f93-9f42-483d10357afb on 05 Jul 2020 23:40:39

RE: Conditional Formatting for Text

Conditional formatting for TEXT Please!

's profile image Profile Picture

b505aa37 a8c6-4188-a162-d50a6bc5f9ad on 05 Jul 2020 23:40:13

RE: Conditional Formatting for Text

The new ability from May 2018 still doesn't resole the original request. Totally agree that a text based conditional formatting would be great, e.g using a 'contains' rather than 'count' where there is a status field