Only show value if the selected period is after a given date in the same row

[NewPBIe]

Hello everybody.

I have a timeline and a table with some scores-column and a date-column as well. 

The date-column has some empty rows and some date. 

Now, I need to show the scores ONLY IF the selected period in the timeline is AFTER the given date in that particular row. 

For example, if I select in the Timeline "Jan 23", I want my table only to show values ONLY if the date is before the selected period (until 31.12.2022). If I select Dec 22 or Nov 22 in the Timeline, I don't want my table to show any values at all. 

Can you maybe help me with this one?

Thank you in advance!

Thank you in advance

[Anonymous]

Hi @NewPBIe ,

Could you please provide more details?

Why when you select Jan 23,the date is before the selected period (until 31.12.2022)? How to get the period? I was very puzzled.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

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

[NewPBIe]

Data:

Table1:

01.01.2000

02.02.2000

03.03.2000

04.04.2000

Table2:

ok	ok
not ok	ok
ok	not ok
ok	ok

Visual Table:

01.01.2000	ok	ok
02.02.2000	not ok	ok
03.03.2000	ok	not ok
04.04.2000	ok	ok

Timeline:

December 99

January 00

February 00

March 00

April 00

May 00

****

Case 1: January 00 is selected

December   99

January 00

February 00

March 00

April 00

May 00

Visual Table: no data to show

01.01.2000
02.02.2000
03.03.2000
04.04.2000

Case 2: February 00 is selected

December   99

January 00

February 00

March 00

April 00

May 00

Visual Table: only first row shows data

01.01.2000	ok	ok
02.02.2000
03.03.2000
04.04.2000

Case 3: March 00 is selected

December   99

January 00

February 00

March 00

April 00

May 00

Visual Table: shows January and February row

01.01.2000	ok	ok
02.02.2000	not ok	ok
03.03.2000
04.04.2000

Does this make sense?