Forum Discussion

tylerbauer's avatar
tylerbauer
Helper II
8 years ago

Building slicers across multiple tables

I have three tables, two from Excel and one from SQL Server. I want to filter all of the tables with one date slicer. I created a Date Table with one to many relationships with each of the three tabl...
Need Help
Rfranca's avatar
Rfranca
Resolver IV
8 years ago

hi, tylerbauer

see the pictures,

 

f

 

Please try and test using it. And please mark the right reply as answer if your issue has been resolved, otherwise, please feel free to ask if you have any other issue.

Best Regards,
Rfranca

tylerbauer's avatar
tylerbauer
Helper II
8 years ago

Hi Rfranca, I tried that but it still isn't working. I was able to make it work for one table with just a DateInt number (01/01/2018 would be 01012018) and it worked. Have you tried this?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    tylerbauer,

    Does your Date table contain all  the possible date values of the other three tables? And If you use DateInt field of Date table to create relationship, do you have DateInt field(whole number data type) in the other three tables? Also please make sure that you use the Date field of the Date table to create slicer.

    Regards,
    Lydia