Stacked Bar Chart with "Other" always at buttom

[Pfoster]

Hello all,

after a long search, I found a solution to create a stacked bar chart, where I have the Top N Countries of Sales and the Rest summarized in "Others". 

To visualize it propably, I need a solution, where I can show "Others" always at the buttom of the stacked bar chart. Currently, it is shown in alphabetic order of the countries. 

Is there a way to regroup the bar chart (ideally: Top N sorted in descending order of sales volumes and then "others"). 

Thank you for any advice!

[Pfoster]

Thank you both, 
I took the "symplier" solution of @danextian. Thanks again for the quick help of you both! 

[danextian · Accepted solution]

Hi @Pfoster 

Legends are sorted alphabetically or by custom sort column.

As an alternative to using a custom sort, you can simply rename "Others" to " Others" (with a leading space) so it appears first in alphabetical order and will be in the bottom stack if sorted in ascending order.

[Akash_Varuna]

Hi @Pfoster For this, you will have to create a custom sort column

SortOrder = IF([Country] = "Others", 0, RANKX(FILTER('Table', [Country] <> "Others"), [Sales], , DESC))

Then, set the Country column to sort by the SortOrder column under  Column Tools > Sort by Column . Then use the Country column in your stacked bar chart, and "Others" will appear at the bottom with the rest sorted by sales.