Sort Column by another Column

[magji]

I have a dataset like below:|

Project	Category	Rank
Proj1	A	1
Proj1	B	2
Proj1	C	3
Proj2	C	1
Proj2	A	2
Proj2	B	3

I will need to put two Slicers:

Slicer 1: Project

Slicer 2 Category 

I Will need to Sort the Category column by Rank column so the values in Category Slicer appear in correct order.

If Proj1 is selected the Category slicer order should be A , B, C.

If Proj2 is selected the Category slicer order should be C, A, B.

If I try to sort the Category by Rank column, I get an error since we have multiple Rank values for the same Category.

[Anonymous · Accepted solution]

Hi @magji ,

The way I can think of is to split the table by project, create two slicers, and use the bookmark + button to control the visibility of the two slicers.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

[magji]

Hi @Jihwan_Kim.
Also the table in the left should be a Slicer.