Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Ask the Fabric Databases & App Development teams anything! Live on Reddit on August 26th. Learn more.

Conditional formatting (cell highligh, font, etc) when comparing multiple fields

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’
Status: Completed
Comments
robin_westerlun
New Member
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!
james_grant
New Member
A must for Power BI!
aaronrusework
New Member
I need both cell and row conditional formatting. Please. Thanks.
syambabu_vemula
New Member
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
nasir_shaikh1
New Member
Great, any timeline decide for it?
Adam_Grove
New Member
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
zgerin
Regular Visitor
This is good, but would it work for doing conditional formatting in a summarized table visualization?
BassMan57
New Member
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.
jashwood1
New Member
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.
v-aldupl
New Member
A great pair to this feature would be the ability to hide the DAX format logic column.