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

2d89085a 2e2f-4b49-b572-10b01fa14d2f on 05 Jul 2020 23:51:40

RE: Conditional Formatting for Text

Please please please add ability to do conditional formatting based on actual text! Would make data cards so much more powerful if I could change font or background color to stand out based on word displayed. For example "Go" would be in GREEN, "No Go" would be in RED

's profile image Profile Picture

a73bd609 1061-4873-8a5b-1d36fdcbd003 on 05 Jul 2020 23:51:21

RE: Conditional Formatting for Text

It would be great if the expansion of this feature allowed for DAX statements as this would really open up the functionality

's profile image Profile Picture

ed49eda2 92bb-445b-95fc-69576dd35690 on 05 Jul 2020 23:51:07

RE: Conditional Formatting for Text

'+1 to conditional formating

's profile image Profile Picture

b1bb04bd 5916-4c72-8f89-0df18a11c4d2 on 05 Jul 2020 23:50:31

RE: Conditional Formatting for Text

Really unfortunate this is not possible. Would be extremely easy to do in a DAX if statement. Please add

's profile image Profile Picture

a075558d ebf9-403f-8d21-ed31c4053a7d on 05 Jul 2020 23:50:17

RE: Conditional Formatting for Text

Hi! Just wondering if we have a conditional formatting feature in Power BI if it's an alphanumeric cell? Thank you!

's profile image Profile Picture

bb5f31c9 52a8-4ad6-a10c-fecff4e105ee on 05 Jul 2020 23:49:12

RE: Conditional Formatting for Text

'+1

's profile image Profile Picture

5f340ed5 f337-491f-ac92-a3a760d188d9 on 05 Jul 2020 23:48:54

RE: Conditional Formatting for Text

I need to be able to format a series of fields (full row) in a table based on a True/False field. It is a really simple,
IF field = True, then color: red, ELSE color: black

's profile image Profile Picture

96ad8e53 31c8-e911-a968-000d3a4f3883 on 05 Jul 2020 23:48:39

RE: Conditional Formatting for Text

It's pretty insane that a functionality this basic would be absolutely impossible in a tool as powerful as this.

's profile image Profile Picture

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

RE: Conditional Formatting for Text

this tool needs the functionality to format text.
really not that hard to add, just add it to the "is" function as part of the "rules" conditionals.

's profile image Profile Picture

e6104092 630c-449d-ade1-17a2076b505c on 05 Jul 2020 23:48:12

RE: Conditional Formatting for Text

'+1