Use Date Slicer across multiple tables

[jdchipps]

Good afternoon I have (at least) 3 tables in my report.  2 of these are direct query from a SQL data Source and have a relationship between them.  The 3rd is a data table that I have created to hold dates in it.

What I need is a slicer on my report that is taken from the date table that then returns data from table one where the date is between  a start and end date (lets call this agreement_start_date), as well as returning information from the second table based on a different start and end date (lets call this one invoice_date).

I only want one slicer, I have achieved this by using a seperate slicer from each table but need to make the report easier for my users,

Hope this makes sense?

[v-lionel-msft]

Hi @jdchipps ,

"that then returns data from table one where the date is between a start and end date (lets call this agreement_start_date), "

"as well as returning information from the second table based on a different start and end date (lets call this one invoice_date)."

Do you want to use a slicer to control two different time periods? I am not sure if it is feasible, can you give a sample data?

Best regards,
Lionel Chen

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

[Tahreem24]

@jdchipps ,

Try to merge the result of both the Dates column into single column.

SingleDate = UNION(DISTINCT(Table1[Datecolumn]),DISTINCT(Table2[DateColumn])

And take this in slicer.