Forum Discussion

ronnoc's avatar
ronnoc
Icon for Advocate II rankAdvocate II
9 years ago
Solved

Sorting legend by largest value

I have a % stacked column chart with - year along the x axis, list of companies as the legend, spend amount as the value       I want the chart to be sorted by largest spend, so the larges...
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    ronnoc

     

    With Summarize you can obtain the expected

     

    SummarizePets =
SUMMARIZE ( Table1, Table1[Pet], "Quantity", CALCULATE ( SUM ( Table1[Q] ) ) )

     

     

Judy's avatar
Judy
Frequent Visitor
9 years ago

Hi,

 

I am looking for someway to show the value of stacked column chart from largest at the bottom and going to the smallest at the top in the chart below. Could you please show me how to do?

 

Thank you for your advice,