Want to sort pie chart by the biggest sum...

[jaryszek]

Hi Guys,

i have pie chart like that:

and as you can see i tried to sort it by Sum of Costs: 

but as you can see The biggest is Spot,  second is Reservation, and Third is SavingsPlan and On Demand from Discountable. 
but in Pie Chart order is different! 

How to address the ordering case? 
Let me attach report example:
https://drive.google.com/file/d/13wn-vSyg5q2mvU5KtWzMSiPZWHDHGxVR/view?usp=sharing 

Best,
Jacek

[v-pnaroju-msft]

Thankyou, @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:

1. Move PricingModel to the Legend well and remove Discountability if you want to sort by PricingModel.
2. 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.

[lbendlin]

Looks like a bug to me. The visual refuses to sort correctly.  Try a different /  custom visual or raise an issue.

[jaryszek]

thank you. It is behaving the same in all my reports. 

Ihave changed to donut but it is the same behaviour, why? Maybe we do not know something about power bi sort behaviour. 

Best,
Jacek

[lbendlin]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .