sort by pie chart

[rveerasamy]

Could you help me out with this one too. I ve created a shape map and i have me legends looking like this now. 

I need them from "0" and "0-2"then to "greater than 10d" in order. Im sure they're the same steps. but could you simplify for me - been using this great software for 2 days so far. 

[v-zhangti · Accepted solution]

Hi @rveerasamy ,

You can try to add Index column in the power query.

Select the Duration column to sort by Index.

At this point, the new sector chart is in the order you expect it to be.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tahreem24]

@rveerasamy Create a column like this:

Sort Column=SWITCH(TRUE(),
Duration="0",1,
Duration="0-2d",2,
Duration="0-5d",3,
Duration="0-10d",4,
Duration="greater than 10d",5)

Then go to Data view select Duration column and go to "Sort by Column" and select the newly created above column "Sort Column".