How can we sort Slices in Pie Chart as we Wanted.

[venkatasuresh_g]

Hi can we sort the Slices of Pie chart as we want in PowerBi . Users want the Visual as shown below , whcih is from XLS .

When I tried to get the data in PowerBi,  PowerBi sorts the slices differently even when I add a index column to sort it won't change sort order , Other goes on top due to Amount or text sorting.

Can I acheive this ?

Thanks 

Suresh  

[Pragati11]

Hi @venkatasuresh_g ,

You can use the sorting options in pie-chart as shown below:

Thanks,

Pragati

[venkatasuresh_g]

Hi Pragati

  I tried all that it doesn't work as expected. You can test  with numbes Cat1-$750 , Cat2-$54, Other-$21

[Pragati11]

Hi @venkatasuresh_g ,

Is your amount value numeric or text?

The left pie-chart which you are trying to achive is achievable by sorting the pie-chart on your amount value ($750, etc.)

Please check your data-type for this amount field.

Thanks,

Pragati

[venkatasuresh_g]

Hi Pragati

 My data is defined as Currency 

[v-yiruan-msft]

Hi @venkatasuresh_g ,

You can make the similar setting as below screen shot for value field:

Best Regards

Rena