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 , 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
Hey amitchandak ,
This worked. I am sure a lotta ppl will get benefitted from this. Thanks again for your time and support. legend.