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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
gabriel_ferrei2
New Member
Do we have an update already?
korleones1
New Member
is there any update?
dhoppa2
New Member
I agree. Conditional formatting at the cell and row level.
jocallaghan
New Member
In addition (as it does not appear to be mentioned specifically in the request), the formatting should not be limited to "measures", or more specifically numeric values, i.e. we should be able to apply formatting based on text/date values too.
Dharris2211
Regular Visitor
Any ETA?
YM
New Member
'+1 for this feature !
cascarlos1
New Member
It would be very important if conditional formatting can apply too at dimensions columns and not only at meassure columns. In several case, it is necesary give the same color to a full row, and if conditional formatting apply only at meassure columns we can not achieve it.
fVoss
Advocate I
kudos!
paragcha
New Member
It still does not directly format based on the comparison like if A>B then highlight color green or else red. We still have to hard code Numerical values or use the Minimum and Maximum as for color coding. Can we perform conditional formatting based on another field only in table visualization? Will this be extended to other visualizations like clustered column too?
V-NAGAM
New Member
'+1 for this feature