4513
It would be great to conditional format a table and/or a matrix based on the cell text, not only numbers
merged ideas 2 Merged Ideas
STATUS DETAILS
Planned
2022 Release Wave 2

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.

P

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

P

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.

P

'+1

P

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"

P

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)

P

'+1

P

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

P

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

P

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

P

Wow, it's pretty ridiculous that this is not a feature.

It takes me less than 10 seconds to do this basic function in Excel, but Power BI ( an incredibly powerful BI tool) can't format based on text value of a field/cell?

All I want is to format all items where Cost="High" with a Red Background.