Forum Discussion
Solved
Conditional Formatting Against Column Totals
Hi All, Need a bit of help with Conditional Formatting against the Column Total (Diff in Sales%). Please Note: Diff in Sales% is a calculated measure. ideally, This is what I want to show. State ...
Rubal_Islam , Oh I was looking at sub total, The logic was on grand total. I created both sub Total and total of Avg and created color on Total (overall avg). File is attached after signature
Rubal_Islam , You can create a color measure
Color =
var _diff = calculate([diff in sales] , filter(allselected(Table), Table[State] = max(Table[State]) ) )
return
Switch(True() ,
Max(Table[State]) ="A" && [diff in sales] < _diff , "Red" ,
// Add other conditions
)
Use the color measure in conditional formatting using the field value option
