Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AndrewDang
Helper IV
Helper IV

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, Washington, Oregon, California, Hawaii) that I want to re-arrange a little different that what PowerBI would give me.

 

Let me know if you have any idea.  Thanks in advance for your help.

Andrew

 

1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

@AndrewDang

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

And even then you won't have complete control.

Pie Chart 1.png

Here's with the Measures...

Pie Chart 2.png

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

View solution in original post

10 REPLIES 10
asitm
Helper III
Helper III

You can use the PBIVizEdit Pie Chart custom visual on the marketplace to do custom sorting

 

https://appsource.microsoft.com/en-US/product/power-bi-visuals/advanceddonutpie

asitm_0-1676296335279.png

 

Sean
Community Champion
Community Champion

@AndrewDang

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

And even then you won't have complete control.

Pie Chart 1.png

Here's with the Measures...

Pie Chart 2.png

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

@Sean

I am new to Power Bi, Could you please help me with Measure , what expression i need to choose to create. So that can seperate data from status column.

 

Regards,

Prateek

Jurgita
Frequent Visitor

I would like to rearage legend in stacked bars, and were redirected here. But what this option i cannot understand well.

If I have bars stucked of 10 items, lets say, should i create 10 measures in order to callcuate each of them and then to use in  values? But this is so unhandy!

Isn't there really a better way to re-oder legend?

 

Murad
Frequent Visitor

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. 

 

legend_driving_me_nuts.png

 

 

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. 

@Murad Couple things. First, If a post is marked as solved, or is really old it is useful to just create your own post. You can still reference the old one if necessary.

Secodn, What is your data source? I recognize the above solution from another thread so I know that if you create another calculated column on the range you will get a circular reference error. Depending on the source of data, if you loaded the sort order (or the ranges) for that matter from the source than it would work with the (Sort by column).

Example, if this is from SQL then you could do a "CASE" statement. If from Excel, you could basically write the same "IF" statement with slight changes in the file for both the range and the sort order column.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Thank you @Seth_C_Bauer and @dkay84_PowerBI - life saving people. 

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

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?

Thanks @Sean for the tip. That should get me going for now.  Ultimately, I would like the ability to "drag and drop" the pies to rearrange them according to my needs.  I don't believe PowerBI supports this feature yet.

 

Thanks;

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.