Forum Discussion
Helper IVRearrange Pies in Pie Chart
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
Community ChampionYou 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
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
Microsoft Employee
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
pjiAdvocate I
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?
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.
Thank you Anonymous and dkay84_PowerBI - life saving people.
