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 tables. These one to many relationships connected a date from the Date Table with different dates in the three tables. The date slicer filter is not working. 

 

Do you have any ideas on how to approach this problem?

Need Help

7 Replies

  • Rfranca's avatar
    Rfranca
    Resolver IV
    8 years ago

    Hi, tylerbauer


    Share the link where I can download your data file to help with the solution.

     

    Best Regards,
    Rfranca

    • tylerbauer's avatar
      tylerbauer
      Helper II
      8 years ago

      Hi Rfrance, unfortunately I can't do that. Do you have any general questions I could answer?

      • Rfranca's avatar
        Rfranca
        Resolver IV
        8 years ago

        hi tylerbauer

         

        check if your PBIX (data and relationship) are according to the image?

        As you can see the query works correctly.

         

         

         

        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