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

    76 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

        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.

      • Luke commented  ·   ·  Flag as inappropriate

        can we use database table driven colours for response?
        ie. answers table;

        Question | Response | BGColour | Text Colour
        happy? | Yes | #0000FF | #000000
        happy? | No | #FF0000 | #000000

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