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

[Beth_Schwenzfei]

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’

[pbiideas1]

Any update? The feature above did not provide the solution.

[ppgandhi112]

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!

[northcraft]

This one is important.

[pbiideas1]

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

[9188040d-6c6100]

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

[akshay_abnave]

Must have features.. basic features must be provided without vote

[sgeddam]

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.

[RoCee]

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.

[purumech40]

'+1 for formatting feature

[DavidD]

Please don't mark this as complete as this does not answer the main issue!