Forum Discussion
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
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
10 Replies
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
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;
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.
- 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
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?
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
