Forum Discussion

jdchipps's avatar
jdchipps
Frequent Visitor
6 years ago

Use Date Slicer across multiple tables

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?

Need Help
Tips and Tricks
Tutorial Requests

2 Replies

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    6 years ago

    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.

     

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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.