Forum Discussion

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
1 year ago
Solved

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

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 Savi...
Need Help
  • jaryszek's avatar
    jaryszek
    1 year ago

    thanks.

    It is not a solution if I am adding legend. 
    There is no way of sorting it then... within Pie Chart

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    1 year ago

    Hi 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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

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

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
1 year ago

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