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 , 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
Rubal_Islam , Please use the [diff %] measure , that should solve the purpose
Hey amitchandak , Unfortunately, it doesn't. Did you run a copy at your end? Can you share your PBIX file with me?
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
This is what i am getting now. Appreciate your help on this Amit.