Forum Discussion
Fab117
Helper IV
Helper IVStacked Column Chart (sorted by Legend – Highest to Lower value)
Hi, In my report, I've several Stacked Column Chart such as: Where "Sum Quantity" is simple measure which does the sum of the field "Quantity" from my table Sum Quantity = SUM(Refe...
hi Fab117
Solution on Right side
I did it with creating a summary tableSummaryTable = SUMMARIZE( 'Table', 'Table'[User], "Total Qty", CALCULATE(SUM('Table'[Quantity])) )Create summary table then sort User with total qty
Create relation with original table
then make your stacked column visual using summary table
hope that solves your issue!
MohTawfik
Resolver I
Resolver Ihi Fab117
Solution on Right side
I did it with creating a summary table
SummaryTable =
SUMMARIZE(
'Table',
'Table'[User],
"Total Qty", CALCULATE(SUM('Table'[Quantity]))
)
Create summary table then sort User with total qty
Create relation with original table
then make your stacked column visual using summary table
hope that solves your issue!
