cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gdxy
Helper I
Helper I

Sort Stacked column Chart by total

Hi,

 

I would like to sort a stacked column chart by the total score, how can I do it? Thank you.

gdxy_1-1664201844101.png

 

 

1 ACCEPTED SOLUTION

not sure if this will help.

but this is how i have sorted my bars basis to total count of value

(this is stacked bar chart and i have added contracts in legend option and sorted the same)

JadhavVarsha_13_0-1664203953198.png

you can try selecting sort descending. 

View solution in original post

5 REPLIES 5
JadhavVarsha_13
Resolver II
Resolver II

Hello,

 

To sort you can click on 3 dots at right corner of Visual and select Sort option from the list. as below 

JadhavVarsha_13_0-1664202839444.png

 

Hope this help !

Thanks for your reply, however, I would like to sort the chart by the sum of all parameters(i.e. DoKPI 1.1+1.2+1.3+1.4+1.5+1.6) instead of a particular one, is there any way to do it? Thanks.

gdxy_0-1664203271039.png

 

not sure if this will help.

but this is how i have sorted my bars basis to total count of value

(this is stacked bar chart and i have added contracts in legend option and sorted the same)

JadhavVarsha_13_0-1664203953198.png

you can try selecting sort descending. 

I add the sum to tooltips and I can now sort by sum, thank you very much 🙂

gdxy_0-1664204587408.png

 

JadhavVarsha_13_1-1664203191281.png

 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors