How to manage Direction of pie chart and Sequence of legend independently?

[Bradley_H]

Hi, 

I am using the Pie Chart below in my report. I can change the "direction" of the Pie Chart by choosing Sort descending or Sort ascending, but the sequence of legend is changing as well. How can I manage the sequence of legend independent from the direction of Pie chart? See below the ideal situation.

Thanks.

[rks · Accepted solution]

I would say you need an additional sort-order column in your data model:

then in the Data Model view you can sort "display" by SorterOrder:

Looks good:

If you want to sort the data visualisation and the legend separately you are probably looking for this feature:
https://ideas.powerbi.com/ideas/idea/?ideaid=6b6f5485-3c57-4584-96dc-42be252595eb