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 ?

this works with a regular stacked column chart too. - sort Type column by Value column - reverse order inside column

Sort columns in Stacked Column Chart | Microsoft Fabric Community

lbendlin
Super User
1 year ago
Use a Ribbon chart. Disable the ribbons if you want.

Advocate II

unfortunately, that doesn't work.

Super User

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-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Advocate II