Sort columns in Stacked Column Chart

[PaisleyPrince]

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]

unfortunately, that doesn't work.

[lbendlin]

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...

[PaisleyPrince]

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 · Accepted solution]

this works with a regular stacked column chart too.

- sort Type column by Value column

- reverse order inside column

[PaisleyPrince]

thanks - works perfectly !

[PaisleyPrince]

Index	Value	Type
1	6	Sixes
2	6	Sixes
2	6	Sixes
3	6	Sixes
3	4	Quads
3	4	Quads
4	6	Sixes
4	6	Sixes
4	6	Sixes
4	6	Sixes
5	6	Sixes
5	6	Sixes
5	5	Fives
5	4	Quads
5	3	Trebles
6	6	Sixes
6	6	Sixes
6	6	Sixes
6	6	Sixes
6	6	Sixes
6	5	Fives
7	6	Sixes
7	5	Fives
7	5	Fives
7	5	Fives
7	4	Quads
7	4	Quads
7	3	Trebles
8	1	Singles
8	1	Singles
8	1	Singles
8	1	Singles
8	6	Sixes
8	3	Trebles
8	3	Trebles
8	2	Doubles
9	6	Sixes

[lbendlin]

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