I am struggling to use an Excel Pivot Table function, like the one you pick a label and simply drag to the left or right in order to change the presentation of a Pie Chart (or any other chart). Let me enphasize that I DO NOT wish to order ascending or descending, because the labels are "TEXTS", so it doesn´t matter what they are, but there is an order I wish to follow. For exaple, period "1-30 days" first, then "30-60 days", then "60-120 days" and finally "Above 120 days".
I cannot think that it is not part of Power BI structure, so please help!
But I do not wish to "Sort" in any way, I wish to change the order manually, like we can do with automated "Pivot-Table Graphs". Basically, for it to work "sorting", I´d have to name the categories in a determined "sortable" way. Sometimes it is not possible. And turning back to the database in Power BI is not the the right move with this great tool.
You problem has been resolved? If you have resolve, please mark the right replay as answer, or welcome to share your solution. Other people will find workaround clearly. If it hasn't, please feel free to ask any issue.
Unfortunately my problem has not been resolved. I really tried the suggestions, either way it did not succeeded. My database is composed by thousands of lines, which are summarized in this pie chart. Not sure that these solutions apply for such a database.
Moreover, these solutions are far more complicated than it should be to solve this simple thing with almighty MS Power BI.
Still waiting for a step-by-step solution to this pie chart question.
Your database is very short. Do you think it works for thousand-long databases, where each of the pie chart slices have more than 500 lines and the size of the slices represent the sum ou count of those hundreds of lines?