Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.