Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

New Member

Multiple Slicer

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?

Community Support
Community Support

Hi @rpmusnijr-wns ,


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.

Super User
Super User

@rpmusnijr-wns , 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

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors