Forum Discussion
Solved
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 follow...
this works with a regular stacked column chart too.
- sort Type column by Value column
- reverse order inside column
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
| 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 |