Forum Discussion

ronnoc's avatar
ronnoc
Advocate 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] ) ) )

     

     

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

ronnoc

 

With Summarize you can obtain the expected

 

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

 

 

ronnoc's avatar
ronnoc
Advocate II
9 years ago

I swear I tried that multiple times!!

 

In any case I tip my hat to you good sir.