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
Is this feature planned to be available for the May 2018 release?
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
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
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
Any ETA?
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
'+1 for the comment about formatting an entire row.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
Also, please add feature to change the colour for entire row. It should be flexible, if developer want to change back ground only for a cell/multiple cell/entire row based on any column value.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
Can we get this feature ASAP, Plz
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
Fantastic!
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
This is an important lack of functionality that has my executives considering another dashboard tool. This simple lack of capability has the potential to eliminate all of the great Power BI PR I have been working on internally. So please do whatever possible to give it focus.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
Great, any timeline decide for it?
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
A quando il rilascio ?