Forum Discussion
Conditional Formatting Against Column Totals
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
Hi amitchandak ,
I am almost there, Can you please help with the below. I think my conditions in the formula are not quite right.
Rubal_Islam , Can create measures only with
calculate([diff in sales] , filter(allselected(Table), Table[State] = max(Table[State]) ) )
and check is that giving correct number to compare
Hey amitchandak , I am also trying to do the calculation based on the measure "Diff in Sales %" instead of "Diff in Sales".
