Custom sort two slicers from same table

[trine_norris]

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:

Key	Column1	Column2
123	2	5
124	2	10
125	2	Free
126	5	5
127	5	10
128	5	Free
129	12	5
130	12	10
131	12	Free
132	Free	5
133	Free	10
134	Free	Free

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?

[harshnathani]

Hi @trine_norris ,

Create 2 tables with index no and link it though the relationship. 

Sort both these tables "sort by column" by index.

Regards,

Harsh Nathani

[harshnathani]

Hi @trine_norris ,

Did the solution work for you.

Please mark as solution for other community members to benefit.

Regards,

Harsh Nathani