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
We need a feature that allows us to visualize some data with icons like traffic lights, flags, and arrows as in Excel. Sorry for my english but I understand a little
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
Can we have conditional formatting on categorical values.?
If Status column is Completed, color = Green
If status column is Running, color = Yellow
If status column is On Hold, color = Red
Thanks
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
it is very important to conditional formatting grid cells basing on values different than the ones contained in each cell. Voted.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
Power BI is useless tool, no vision what they delivering as a product... its something half-boiled product and not good enterprise.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
I totally agree this enhancement should be priority.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
I think at the very least the conditional formatting options should be on a par with what Excel currently has.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
Fundamental capability available in Tableau and other tools. 2 similar requests have been logged.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
Basic function even in lesser tools such a Excel. Must have if we are going to adopt Power BI as standard visualization tool.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
Great request - same as
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19385893-conditional-formatting-cell-highligh-font-etc
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
Current BI tool has this feature...would be a major show stopper if BI cannot.