need two visuals filtered by the same field, but the filtered columns must be different

[beewoop]

so i have a table, table1, where i have a list of records. each record, desirebly, has START date and DUE date, hence table1 has columns called START and DUE respectively. i also have Calendar table, where i have Date column, that is related one way to table1[DUE]. 

i need to create two visuals, pretty much identical, that will display records. one must contain START, the other one DUE. 

both visuals must be filtered by Calendar[Date], and when i select date range, like month, both START and DUE must show records that are within this date range. for example, if i select May2024, i need visualA to show all records where START is May2024, and visualB to show all records where DUE is May2024.

as example, below is my table1

Record Number	START	DUE
INC127	25 Mar 2024	17 May 2024
INC646	31 May 2024	7 Jun 2024
INC763	8 May 2024	23 Jul 2024
INC654	15 Apr 2024	8 May 2024
INC083	2 Feb 2024	19 May 2024

and when i use Calendar[Date] as filter, selecting May24,

visualA should then look like this

Record Number	START
INC646	31 May 2024
INC763	8 May 2024

 and visualB should look like this 

Record Number	DUE
INC127	17 May 2024
INC654	8 May 2024
INC083	19 May 2024

unfortunately, because Calendar[Date] is related to DUE, i get visualA with records where DUE is within filtered range  like this

Record Number	START
INC127	25 Mar 2024
INC654	15 Apr 2024
INC083	2 Feb 2024

[barritown · Accepted solution]

Hi @beewoop,

One of the options is to create another, standalone calendar table for your slicer.

Then compose a couple of measures like that:

flagSTART = INT ( SELECTEDVALUE ( 'Table'[START] ) IN VALUES (DATES[Date] ) )

flagDUE = INT ( SELECTEDVALUE ( 'Table'[DUE] ) IN VALUES ( DATES[Date] ) )

Then use them for additional filtering in your visuals:

Please check the attached file with this approach realized.

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian