Custom sort two slicers from same table

Hi!

Really hope someone can help!

I have two slicers that corresponds to two different columns in the same table. 

I want to do custom sorting on both slicers, however i cannot seem to make this work.

The table looks something like this:

I have tried creating a new table with the distinct values for column1 and the sort order, and then used the function "sort by column", which works for column1. However, I cannot seem to do this for the second column as well - in this case it tells me that the table is already sorted. Can anyone help?