topic Custom sort two slicers from same table in DAX Commands and Tips

Custom sort two slicers from same table

trine_norris — Tue, 21 Apr 2020 13:40:40 GMT

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?

Re: Custom sort two slicers from same table

Anonymous — Tue, 21 Apr 2020 18:40:59 GMT

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

Re: Custom sort two slicers from same table

Anonymous — Sat, 15 Aug 2020 21:37:16 GMT

Hi trine_norris ,

Did the solution work for you.

Please mark as solution for other community members to benefit.

Regards,

Harsh Nathani