Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to create one date slicer with multiple date fields from multiple tables

I have three tables in my report.  Each table has a date field.  I would like to create one date slicer that will control all three tables, however, in each of my tables the date fields have different names- Transaction Date, Received Date and Transaction Date.  I have tried synching and grouping the slicers but it does not control all three tables.  Here is my sample report.  

 

 

Here is my model.  I have all three talbes connected to the date table. 

Any help would be greatly appreciated.  Thank you in advance! 

 

 

4 Replies

  • Hi,

    have you tried using only one slicer with Date from DimDate?

    • Anonymous's avatar
      Anonymous
      Not applicable

      Yes  I tried using the date from the DimDate, it will only filter two of the tables not all three.

      • serpiva64's avatar
        serpiva64
        Icon for Solution Sage rankSolution Sage

        Which one is not filtering? Be sure of that relationship.