Multiple values to filter data

Hi Anonymous ,

Analyzing what you wrote, you want the user to be able to select Load or Delivery Location and see all contracts that apply to a given location.

Proposed solution:
1. I would bring the table to this form. Thanks to this, you have a simple division of where to deliver from.

2. To achieve the effect you mentioned, you need to have two additional tables that will be such a dictionary - a combination of the contract and load location or delivery location.

Load Location: 

Delivery Location:

3. Having these two tables, you should connect them via Contract ID to the main table.

4. And then create two slicers that will help the user find the right order.

_____

Memorable Member | Former Super User If I helped, please accept the solution and give kudos!  Linkedin