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

70bb2315 8a46-4264-965e-6101f7f74a8b on 05 Jul 2020 23:25:33

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

's profile image Profile Picture

70bb2315 8a46-4264-965e-6101f7f74a8b on 05 Jul 2020 23:25:33

RE: Conditional Formatting for Text

This is great. It would be awesome if "data bars" conditional formatting option is made available for text

's profile image Profile Picture

4690aad3 d60f-44d2-a17a-69788bfb10ce on 05 Jul 2020 23:24:32

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.

's profile image Profile Picture

c90f58e2 b44b-4a97-aa4f-8a30c1773a8a on 05 Jul 2020 23:24:25

RE: Conditional Formatting for Text

need to be able to format on TEXT, ie Status, green = on track, red = behind

's profile image Profile Picture

6591cdee 6a96-4585-af0a-a0e72f59c66e on 05 Jul 2020 23:23:38

RE: Conditional Formatting for Text

Conditional formatting of text 'containing' X please!

's profile image Profile Picture

6591cdee 6a96-4585-af0a-a0e72f59c66e on 05 Jul 2020 23:23:37

RE: Conditional Formatting for Text

conditional formatting THE SAME as in excel

's profile image Profile Picture

6ccc7e68 abad-4133-b9f6-02cdca512026 on 05 Jul 2020 23:22:16

RE: Conditional Formatting for Text

Great! Cant wait to have it!

's profile image Profile Picture

6ccc7e68 abad-4133-b9f6-02cdca512026 on 05 Jul 2020 23:22:14

RE: Conditional Formatting for Text

Great! Cant wait! Lets just have the option to say IF State = 'Washington' Color it 'Green' IF State = 'Arizona' then color the text cell Orange.

's profile image Profile Picture

31119ba3 f932-4ed1-af52-ff2eda680ac6 on 05 Jul 2020 23:22:02

RE: Conditional Formatting for Text

Thank god.

's profile image Profile Picture

75611dc0 d0fb-4497-8221-e965bacf336e on 05 Jul 2020 23:20:50

RE: Conditional Formatting for Text

Woo Hoo conditional formatting on text!