Skip to main content

Power BI

Planned

Conditional Formatting for Text

Vote (4703) Share
Power BI User's profile image

Power BI User 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 20 Jul 2024 20:49:20

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 (151)
Power BI User's profile image Profile Picture

Power BI User 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

Power BI User's profile image Profile Picture

Chris Greenwood 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.

Power BI User's profile image Profile Picture

Power BI User 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.

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:48:12

RE: Conditional Formatting for Text

'+1

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:48:11

RE: Conditional Formatting for Text

I echo this comment -
"Seems like a no-brainer. It would be very useful to have a DAX function to set font color/background conditionally: IF([A]-[B]=0,FORMAT("In Balance","Color:Green"),FORMAT("Out of Balance",Color:Red"

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:47:35

RE: Conditional Formatting for Text

Seems like a no-brainer. It would be very useful to have a DAX function to set font color/background conditionally: IF([A]-[B]=0,FORMAT("In Balance","Color:Green"),FORMAT("Out of Balance",Color:Red)

Power BI User's profile image Profile Picture

Ghuiles on 05 Jul 2020 23:47:34

RE: Conditional Formatting for Text

'+1

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:47:18

RE: Conditional Formatting for Text

Crazy that this doesn't exist! Is this on the roadmap yet?

Power BI User's profile image Profile Picture

Michael Garrity on 05 Jul 2020 23:47:17

RE: Conditional Formatting for Text

Are there more plans to make this functionality better?
It would be really great to conditionally format based on "TEXT" criteria, and well as using "IF" statements

Power BI User's profile image Profile Picture

Mahindra Bisram on 05 Jul 2020 23:46:53

RE: Conditional Formatting for Text

I also need this functionality to format based on field value. For example, I need to format a field as follows :
Current=Green
Grace=Yellow
Expired=Orange
Closed=Red

Merged Idea (2)