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
another of nonsensical pitfalls of Power BI - how can this be not built in after 2 years? Microsoft should pay users to use Power BI, not the other way around. what a joke.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
Can we please have this feature? Having to create a separate numeric field for each text field we want to format is very cumbersome. FYI Google Sheets and Excel support this out of the box (just apply conditional formatting rule such as "text contains"), so it's really puzzling why after nearly 3 years the Power BI team still hasn't delivered
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
Please could we add the same functionality for conditional formatting that is possible with Excel as this would make displaying the data a lot easier on what needs to be highlighted or emphasis on certain patterns
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
this is really sad. how can PBI not allow conditional formatting for text but Excel does? shameful. truly pathetic lol.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
Please add icons in conditional formatting similar to excel
Also, kindly add the features of formatting such as that available in excel for tables such as borders, coloring, headers.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
I am also looking for Conditional formatting on more than 1 fields.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
I can't find this exact feature anymore. Has it been changed/removed recently?
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
We need formatting based upon text value of column as well.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
I can't find this feature anymore in the latest PowerBI release. Is it still available?
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
Please don't mark this as complete as this does not answer the main issue!