Forum Discussion

AndrewDang's avatar
AndrewDang
Icon for Helper IV rankHelper IV
10 years ago
Solved

Rearrange Pies in Pie Chart

Hello all;   I am wondering if there is a way that we can re-arrange the positions of the pies in a pie chart.  Let say that I have a pie chart of population of states in the pacific (Alaska, Washi...
  • Sean's avatar
    Sean
    10 years ago

    AndrewDang

    You have to create separate Measures to Calculate the Population for each State.

    And even then you won't have complete control.

    Here's with the Measures...

    Dragging the Measures in the Values area up and down doesn't always work

    You may have to start with a new pie chart and change the order in which you add each State to the pie

     

    Whether this is worth it depends on how many states you have

Murad's avatar
Murad
Frequent Visitor
9 years ago

Hello Sean , 

 

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 "1-3" and then to "30-35" 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. 

 

Regards,

Murad. 

dkay84_PowerBI's avatar
dkay84_PowerBI
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago
You need to create a separate column that provides a numeric order for those string values. Then, on PBI desktop UI, under the "modeling" tab is a "sort by" option and you choose the order column you created
  • pji's avatar
    pji
    Icon for Advocate I rankAdvocate I
    9 years ago

    It doesn't seem to work for me this way. I tried addine a new sort column. Could you may be share an example or a screenshot for this, if possible?