Select a value in a visual, and then filter another visual with conditions around the selected value

[Anonymous]

Hi all! I would like to seek your help on the below. I would like to select a value on the first visual, and have the second visual filtered with additional conditions.

There are 2 visuals. The first one below:

Time

1 June 2021 00:00

1 June 2021 00:15

1 June 2021 00:30

1 June 2021 00:45

The second one below:

Aircraft        Arrival time                Departure time

Aircraft 1    1 June 2021 00:08      1 June 2021 00:25

Aircraft 2    1 June 2021 00:12      1 June 2021 00:40

Aircraft 3    1 June 2021 00:34      1 June 2021 00:50

Aircraft 4    1 June 2021 00:40      1 June 2021 01:05

I would like that the second visual is filtered in a manner that,  it will only show the items if the selected value in the first visual (e.g 1 June 2021 00:15) is between the arrival time and departure time in the second visual. In other words, if 1 June 2021 00:15 is selected, the second visual will only show Aircraft 1 and Aircraft 2. 

I am not sure how to create these conditional filters on top of a selected value... Truly appreciate your help on this!

Cheers

Tim

[v-yetao1-msft · Accepted solution]

Hi @Anonymous 

You can use the time table as a slicer to filter the data in data table . And then create a measure to display the result .

Measure = CALCULATE(SELECTEDVALUE('Table'[Aircraft]),FILTER('Table','Table'[Arrival time]<MAX('Time'[Time]) && 'Table'[Departure time]>MAX('Time'[Time])))

The effect is as shown :

I have attached my pbix file ,you can refer to it .

Best Regards

Community Support Team _ Ailsa Tao

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

[Anonymous]

@v-yetao1-msft  Thank you so much for your help! It worked perfectly.

Cheers,

Tim

[Anonymous]

Thanks @Anonymous ! Could you advise what expressions to use if I were to write that measure? 

[Anonymous]

@Anonymous 

The two tables have to be disconnected from each other, first of all. Second, you create a measure that you'll use in the Filter Pane of the visual. If it's value is 1, show the row. If 0, hide it. That's how you do it. Of course, it's up to you to write the measure since you've got all the bits and pieces about your model which we don't.