Forum Discussion

swong's avatar
swong
Helper II
9 years ago
Solved

stacked graph order

Hi,   I have a stacked bar chart, and the different segments are:   Exact, Full, Partial, Traditional   My bars are stacked in that order (alphabetical), with "Exact" on the bottom and "Traditi...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi swong,

     

    Currently, it is not supported to sort the chart based on legend. Someone has submitted this feature request, you can clisk to vote it up. Custom order for legend in stacked bar chart

     

    As a workaround, you could create Measures for each segment. Then place each Measure in the Values area in the order you need. However, this workaround might not apply to the scenario where you have many legend items.

     

    Regards,
    Yuliana Gu

wynhopkins's avatar
wynhopkins
Most Valuable Professional
8 years ago

I think I have a solution to this.

 

If you set up a separate Table (use Enter Data) containing Exact, Full, Partial, Traditional  and then type 1,2,3,4 in the column next to it you can then connect that to your table that is currently being used in your chart.

 

Use this new column of of segment names in your chart instead of the original ones.

 

You can then use the Sort By Column option under Modelling to get your segments to show any order you want.