How to combine multiple range slicers with AND logic

[AgencyPowerBi]

Hi,

I'm trying to filter lot of data through the use of couple of range slicers. What I found out is that these are connected with OR logic, so my result table still contains a lot of instances where parameters are not one I would like.

How can I connect range slicers with AND logic and filter table more accuratelly.

live table is on http://bit.ly/Reach-it

Circeled slicers should combine in one AND filter for the table above.

So, if someone could help, I would be much obliged.

Tx

[v-xicai · Accepted solution]

Hi @AgencyPowerBi ,

You might create relationships among these tables related the slicers above first of all, recommend you create the star schema instead of circle schema for the data model , then change the Cross filter direction of all relationships from Single to Both , which will take these tables treated as a single table. See more about relationship :https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships.

Then when you make some selections in slicers, the other visuals will return corresponding result.

Best Regards,

Amy

Community Support Team _ Amy

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

[AgencyPowerBi]

That is great help, thanks.

I did all my matching through proxy table with index column. It would be much simpler if I was to connect everything to one table, as you suggested 🙂

Thank you once again.

Best,