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
Could not imagine this simple feature is unavailable when I started to use Power BI at first.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
we need the ability to conditional format by column based on different values related to that column... So I want column A to have color formatting based on different criteria than column B. Currently i am only aware you can do conditional formatting on one column
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
Need to also be able to conditionally format based on a field that is not a measure. You should be able to conditionally format based on any field type; Text, Date, Number, Etc - this is reporting 101
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
We need expressions everywhere, not only formatting. I run daily into the limitations PowerBI has.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
COLOR DIVERGING AND CONDITIONAL FORMATTING FOR DATE COLUMNS WOULD BE GREAT EITHER!
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
We need arrows, flags like in Excel =)
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
It would also solve the problem of conditional formatting based on a different measure.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
If we can get conditional formatting based on other cells in the row available, then folks can add baby images as a cell type separately (arrow, circle, stoplight, baby chickens, whatnot) and be able to colorize them etc based on this which is needed first.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
Yes, exactly, what would also be good to be able to use your own image url's in the matrix tables as values, or if the image url's could be integrated into conditional formatting interface. For a service health dashboard, you really need a matrix table with the values as the service health icons. E.G. Rows would be the name and columns would be the date, then values would be an icon set representing an outage or green checkmark, etc....
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
I abandoned power bi in favour of excel with powerquery and powerpivot.
This formatting is available in excel but not in power bi!