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,321 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    65 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • 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.,

      • Lars Bien commented  ·   ·  Flag as inappropriate

        I hope this feature will be added on the next update/release this will greatly help our customization of our dashboards!

      • Anonymous commented  ·   ·  Flag as inappropriate

        As of February 12 2019 I still cannot conditional format for text, even though I changed the data type of the column to "Text". This is a feature I often used in excel to compare mismatching columns, text that started with XYZ or contained XYZ.

        Why does Power Bi insist on turning all my text columns into "Count"? So frustrating.

      • E commented  ·   ·  Flag as inappropriate

        The new ability from May 2018 still doesn't resole the original request. Totally agree that a text based conditional formatting would be great, e.g using a 'contains' rather than 'count' where there is a status field

      • juan commented  ·   ·  Flag as inappropriate

        Hi, any news about this possible new feature.... Is a must have ..

      • B Brown commented  ·   ·  Flag as inappropriate

        What about just having conditional formatting NOT based on a number field but just on the text (i.e., categorical value).

      • Jed Hansen commented  ·   ·  Flag as inappropriate

        By date comparisons, as well. Example - if 14 days past 'today', highlight as red. This would be highly valuable for time sensitive charts and data tables - chasing AR, etc.

      • Anonymous commented  ·   ·  Flag as inappropriate

        This should be something basic. I appreciate that you guys have added formatting by another numeric field. But because I'm a human and not a computer it's user to read words than numbers.

        All of my tables have status columns, sometimes they're boolean true/false, sometimes they're text. EmployeeStatus: Active/Leave/Retired. VehicleStatus: Current/Sold. Insurance&Tax: Valid/Expired etc....

        Now, I can go and add some more helper columns to covert each category into a number that can be recognized for conditional formatting (as if I haven't added enough helper columns already for Power BI workarounds) but shouldn't it be as simple as
        Select column to format:
        Format values that [!equal/!contain/!begin with] "Expired" colour "Red"
        This is bonkers for a tool at this level

      • Robert commented  ·   ·  Flag as inappropriate

        I would like to be able to conditionally format based on certain text values entered in as a formula like ="Davey Jones". This would be useful, thanks.

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