How can we improve Power BI?

Conditional formatting (cell highligh, font, etc) when comparing multiple fields

PowerBI needs to have the ability to offer conditional formatting of based on the comparison of 2 or more metrics. For example if metric A = metric B then change the font and highlight color of the cell to red.
If metric A > metric B and metric A < metric C then change the font and highlight color of the cell to green.
This should be unlimited for how many colors can be used. Other BI tools offer this feature.
Note that this is different than what PowerBI currently calls ‘conditional formatting’

1,742 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 →

    As of our May release, you can now conditionally format a column by another field. Which means you can create a column that does your comparisons and then use that to format anything in your table or matrix. If you have other suggestions for conditional formatting options, make sure to vote on those as well!

    https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#conditionalFormatting

    78 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Andreas Rossi commented  ·   ·  Flag as inappropriate

        This is not completed. The may release does not cover all the needs when it comes to highlighting single cells based on the value in it.

      • sGedd commented  ·   ·  Flag as inappropriate

        Can we apply conditional formatting to strings as well? My client wants to be able to click on a row in a table and have all of the other related rows in that table to be highlighted. My entire data set is string-based rather than integer-based, so I am unable to use conditional formatting.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Still have a need for this type of conditional formatting on the data bars - based on rules using another field.

      • Prashant Gandhi commented  ·   ·  Flag as inappropriate

        Power BI is a powerful tool used by executive management personnel who are more interested in comparative figures etc. this feature will be a very good to have. Thanks!

      • Dan Thompson commented  ·   ·  Flag as inappropriate

        Hi, could the conditional formatting be extended to control entire rows as well? Also can the font be controlled using conditional formats as suggested in the original post? Thanks, Dan

      • Carlos commented  ·   ·  Flag as inappropriate

        It would be very important if conditional formatting can apply too at dimensions columns and not only at meassure columns.
        In several case, it is necesary give the same color to a full row, and if conditional formatting apply only at meassure columns we can not achieve it.

      • Parag commented  ·   ·  Flag as inappropriate

        It still does not directly format based on the comparison like if A>B then highlight color green or else red. We still have to hard code Numerical values or use the Minimum and Maximum as for color coding.
        Can we perform conditional formatting based on another field only in table visualization? Will this be extended to other visualizations like clustered column too?

      • John commented  ·   ·  Flag as inappropriate

        In addition (as it does not appear to be mentioned specifically in the request), the formatting should not be limited to "measures", or more specifically numeric values, i.e. we should be able to apply formatting based on text/date values too.

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