Manually sort 100% stack bar chart

Alisea_MI 

Go to the table where you have the Category field and add a sort column then sort the Category column based on that using "Sort By Column":

For a custom sort order, go to Power Query > Add Conditional Column. Populate the pop-up menu selecting the column where your range values are similarly like this:

Then, Close & Apply. Go to the Data View. Select the Range Values column, look for the Sort By Column Option in the top menu and select Sort By Sorting_Column.

That will do it. Just ensure that your visual is sorted by the range values column. 

Hi Alisea_MI 

You can add a column to sort your category . In Query Editor , add a conditional column like this :

Then in desktop view , add a 100% stack bar chart visual , in Axis ,add category and custom column .Sort by Custom and column 1 , in ascending order .

The final result is as shown :

I have attached my pbix file ,you can refer to it .

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.