Forum Discussion
Solved
Sort based on Total values in stacked bar chart
I have a requirement in which sorting has to be done based on total values of two columns used in stacked bar chart. Below screenshot we have two direct amount columns in X axis requirement is to so...
karthik77700 - so in this case you need to create a DAX measure for the total, this will be:
SUM ( 'Table'[Ret Amount] ) + SUM ( 'Table'[Ced Amount] )Just replace the word Table with your table name. Then add this to the tooltip as I showed in my screenshot.
If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!
It worked Thanks for your support