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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
PaisleyPrince
Helper II
Helper II

Sort columns in Stacked Column Chart

Hi, I have a stacked column chart which i require to sort in two ways. The x axis sorted by an index (1-23) and the bars in the column sorted by category and not value with sixes at the bottom followed by fives etc. I have attached sample data below. I'd be grateful for advice on how to sort the bars in each column ?

PaisleyPrince_0-1734807938067.png

 

1 ACCEPTED SOLUTION

lbendlin_0-1734872145763.png

this works with a regular stacked column chart too.

 

- sort Type column by Value column

- reverse order inside column

 

 

View solution in original post

7 REPLIES 7
PaisleyPrince
Helper II
Helper II

unfortunately, that doesn't work.

I'm sure it does - I use it nearly every day.

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

I have provided sample data as per the table below. The output should be the x axis sorted by index and the bars sorted in ascending order by type. With sixes followed by fives, then quads, trebles, doubles and singles). Hope this provides enough detail ?

lbendlin_0-1734872145763.png

this works with a regular stacked column chart too.

 

- sort Type column by Value column

- reverse order inside column

 

 

thanks - works perfectly !

IndexValueType
16Sixes
26Sixes
26Sixes
36Sixes
34Quads
34Quads
46Sixes
46Sixes
46Sixes
46Sixes
56Sixes
56Sixes
55Fives
54Quads
53Trebles
66Sixes
66Sixes
66Sixes
66Sixes
66Sixes
65Fives
76Sixes
75Fives
75Fives
75Fives
74Quads
74Quads
73Trebles
81Singles
81Singles
81Singles
81Singles
86Sixes
83Trebles
83Trebles
82Doubles
96Sixes
lbendlin
Super User
Super User

Use a Ribbon chart.  Disable the ribbons if you want.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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