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.
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.
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
@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.