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

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

84 comments

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

    Please add icons in conditional formatting similar to excel
    Also, kindly add the features of formatting such as that available in excel for tables such as borders, coloring, headers.

  • Johnny commented  ·   ·  Flag as inappropriate

    I can't find this exact feature anymore. Has it been changed/removed recently?

  • Anonymous commented  ·   ·  Flag as inappropriate

    I can't find this feature anymore in the latest PowerBI release. Is it still available?

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

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