Forum Discussion

pr92's avatar
pr92
Frequent Visitor
3 years ago
Solved

Filter visual based on slicer on column from another table

Hello,   I have the following database model with 3 tables : Clients, Sales, DateTable     "Clients" is linked to "Sales" on "client_id" "Sales" is linked to "DateTable" on "order_date" ...
Need Help
Tips and Tricks
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    Hi pr92 ,

     

    For the sake of simplicity, I'd just change the relationship between Clients and Sales to bi-directional.

    As an aside - once you have a properly-related calendar table, you should be using the calendar fields in slicers and visuals, not the fact fields.

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
3 years ago

Hi pr92 ,

 

For the sake of simplicity, I'd just change the relationship between Clients and Sales to bi-directional.

As an aside - once you have a properly-related calendar table, you should be using the calendar fields in slicers and visuals, not the fact fields.

 

Pete

  • pr92's avatar
    pr92
    Frequent Visitor
    3 years ago

    Thank you - that worked.