Forum Discussion
Helper ISort based on Total values in stacked bar chart
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!
Helper II havent created any measure they are just two direct columns(Ret Amount and Ced amount) used in X axis and there is no legends added as well.Just enabled legends in format field .how to write expression for this
Super Userkarthik77700 - 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!