Forum Discussion
Super UserWant to sort pie chart by the biggest sum...
thanks.
It is not a solution if I am adding legend.
There is no way of sorting it then... within Pie ChartHi jaryszek,
Thankyou for the update.
Based on my understanding, in Power BI the slices of Pie and Donut charts cannot be sorted independently when no Legend is provided. The sorting options apply only to the field placed in the Legend well. Consequently, in the absence of a Legend there is no way to enforce a specific order for the slices.
We kindly request that you submit an idea for this feature for the built-in Pie and Donut visuals via the Microsoft Fabric Ideas portal using the link: Fabric Ideas - Microsoft Fabric Community
If you have any further queries, please feel free to contact the Microsoft Fabric community.
Thank you.
Community SupportThankyou, lbendlin, for your response.
Hi jaryszek,
We appreciate your inquiry on the Microsoft Fabric Community Forum.
Based on my understanding, the pie chart is not sorting as expected because sorting in Power BI applies to the field placed in the Legend well. In your report, Discountability is in the Legend while PricingModel is in the Details. Therefore, the sort option applies only to the two Discountability values and not to the individual PricingModel slices.
Please follow the steps below, which may help resolve the issue:
- Move PricingModel to the Legend well and remove Discountability if you want to sort by PricingModel.
- On the chart, click More options (…) and select Sort, then choose Sum of CostInBillingCurrency and select Sort descending. This will order the pie slices from largest to smallest value.
Please find the screenshot attached below:
We hope the information provided helps resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric Community.
Thank you.
- jaryszek
thanks.
It is not a solution if I am adding legend.
There is no way of sorting it then... within Pie Chart