Power BI
CompletedConditional formatting (cell highligh, font, etc) when comparing multiple fields
on 24 May 2017 19:48:36
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’
Administrator on 09 May 2018 05:39:06
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
- Comments (88)
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
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.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
'+1 for formatting feature
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
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.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
Still have a need for this type of conditional formatting on the data bars - based on rules using another field.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
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!
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
Must have features.. basic features must be provided without vote
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
This one is important.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
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
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
Any update? The feature above did not provide the solution.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
'+1 for this feature