Multiple Slicer

[Anonymous]

I am trying to create multiple slicer to sort 2 tables, I was able to create one relationship (Many to Many) but when I tried to create a few more relationship to be able to sort multiple data I was not allowed. May I ask how to go about sorting 2 tables please with multiple slicers?

[Anonymous]

Hi @Anonymous ,

Sorry for that the information you have provided is not making the problem clear to me.

If you want to dynamically sort fields, you may use RANKX() function of DAX to sort.

Please provide me with more details about your table and your expected outputs or share me with your pbix file after removing sensitive data.

Refer to:

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , why do need to create creation to sort the data ?

Two tables can join on one column each. If you need more than one column in join, concatenate columns

More than one join will result in inactive joins

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi