Forum Discussion
Customized Order For Sunburst Chart
Hi all!
I'm currently trying to work on a sunburst chart that shows data from a sequence of seven steps. The issue is, the Microsoft sunburst chart seems to auto-sort by the value of each sub-category or "step", meaning it shows data in a seemingly random order (i.e Step 6 -> Step 3 -> Step 4 -> etc.).
Has anyone got a way that I could force the chart instead to render the data in an order I want (Step 1 -> Step 2 -> Step 3 -> etc.)? I've tried using the classic "Sort Order" column trick but with no success. A sample of the data is below.
| Step | Type | Sort Order | Total |
| 1 | Type A | 1 | 50 |
| 1 | Type B | 1 | 200 |
| 2 | Type A | 2 | 175 |
| 2 | Type B | 2 | 600 |
| 3 | Type A | 3 | 800 |
| 3 | Type B | 3 | 1200 |
| 4 | Type C | 4 | 120 |
| 5 | Type A | 5 | 125 |
| 5 | Type B | 5 | 500 |
| 6 | Type A | 6 | 600 |
| 6 | Type B | 6 | 20 |
| 7 | Type A | 7 | 100 |
| 7 | Type B | 7 | 15 |
Thanks in advance!
Hi Harry41
In Power BI, the default behavior for the Sunburst Chart is to sort the segments (also known as "rings" or "levels") by the value size of each segment. This sorting method is intended to make the largest items more prominent, so they typically appear at the top or the beginning of the chart.
Unfortunately, the Sunburst Chart's design does not allow for a direct modification of the sorting logic, as its primary design intention is to show the size relationship of hierarchical data.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Harry41
In Power BI, the default behavior for the Sunburst Chart is to sort the segments (also known as "rings" or "levels") by the value size of each segment. This sorting method is intended to make the largest items more prominent, so they typically appear at the top or the beginning of the chart.
Unfortunately, the Sunburst Chart's design does not allow for a direct modification of the sorting logic, as its primary design intention is to show the size relationship of hierarchical data.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.