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
As said below please make it such that the DAX measure for the conditional formatting does not need to be visible in the table/matrix, i.e. I would like to show a single measure in a matrix but colour based on another measure. This is a feature we are really looking forward to. Thanks
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
Great news that you started work on this feature as it really is a basic BI requirement, so thx, makes Power BI viable as a BI frontend. Now enable 32-bit connections for the gateway and I'm ready to go :)
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
A great pair to this feature would be the ability to hide the DAX format logic column.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
This is good, but would it work for doing conditional formatting in a summarized table visualization?
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
Yet another missing basic feature that every Enterprise BI product (including SSRS now
almost 20 years old) has had for years.
Come on guys, at least respond.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
I need both cell and row conditional formatting.
Please. Thanks.
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
There should be a provision to apply the format to entire row as well.
Apart from this, this should able to apply conditional formatting on text data of measure as well as row header data
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
So weird that this feature was not added at the same time as color formatting was added as a feature.
I would like to add a comment regarding the option to set the measurement to either a related cell or a defined parameter. Since we have dynamic parameters either option would be a possible fix for different kind of representations.
Please vote for this feature!
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
A must for Power BI!
RE: Conditional formatting (cell highligh, font, etc) when comparing multiple fields
We need to have this, to have table cell color coded based on comparison with other field, currently there is no functionality. Must required in Power BI.