Forum Discussion

MarcUrdang's avatar
MarcUrdang
Post Patron
6 years ago
Solved

Sorting in a stacked bar chart

Hi .. I have a stacked bar chart where I sort the x axis by date which works fine. However each bar is stacked by a value per branch. How do I sort each column by the highest value at the bottom up t...
Need Help
MarcUrdang's avatar
MarcUrdang
Post Patron
6 years ago

Hi Jay

thanks for coming back to me. Ok let me explain again .. sorry for the confusion.

 

the bar graph must be sorted along the x axis by date .. works fine

however when trying to sort each bar which is segmented by BRANCH from biggest to smallest based on VALUE the error message says it can't sort by two different fields?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi MarcUrdang ,

 

So assume the picture below is raw visual.

You want the visual sort by legend i.e show as 20200201 c, b, a; 20200102 c, a, b; 20200103 a, b, c; etc... Am i right?

In that case i'm afriad this can't be done in Power BI currently.

About this feature, there are several ideas have been submit , you can vote for them.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31937392-legend-manual-sorting.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/37921429-sort-order-legend.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17547193-if-i-can-sort-the-stacked-bar-dimensions-by-legend.

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello Anonymous,

    Is it still not possible to do this kind of sorting with PowerBI ?

    Thanks in advance for your response 🙂