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,578 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 →

83 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Janet Walker commented  ·   ·  Flag as inappropriate

    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

  • Anonymous commented  ·   ·  Flag as inappropriate

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

  • jacob commented  ·   ·  Flag as inappropriate

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

  • Joyce Capina commented  ·   ·  Flag as inappropriate

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

  • 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

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

← Previous 1 3 4 5

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.