How can we improve Power BI?

Conditional Formatting for Text

It would be great to conditional format a table and/or a matrix based on the cell text, not only numbers

1,444 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

78 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    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

  • Chris Greenwood commented  ·   ·  Flag as inappropriate

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

  • Anonymous commented  ·   ·  Flag as inappropriate

    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.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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"

  • Anonymous commented  ·   ·  Flag as inappropriate

    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)

  • Michael Garrity commented  ·   ·  Flag as inappropriate

    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

  • Mahindra Bisram commented  ·   ·  Flag as inappropriate

    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

  • Sancho commented  ·   ·  Flag as inappropriate

    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.

  • Chris Holloway commented  ·   ·  Flag as inappropriate

    It's a feature that seems so basic, but is surprisingly missing. I would agree with the others that we should be able to have conditional formatting based upon string matching.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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.,

← Previous 1 3 4

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.