Forum Discussion
Dynamic range date slicer
Hello, I need help with a dynamic date slicer please... So, I have two tables, one with client contract info and another with historic info from multiple clients. I need to have a dynamic dat...
Hi lizardi89 ,
The reason the date slicer return this result is because of your data model.
In fact, there is a 1: 1 relationship between the Contracts table and the "Cal Filter" table, and a *：1 relationship between the "Historic Data" table and the "Cal Filter" table (the "1" table to filter the " *" table), so you cannot use the [Sourcename] column to filter out the date range.
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.
Hi Lionel,
Thank you for your help, would there be any way to fix the model to achieve what I need to do?
Thank you for your help, would there be any way to fix the model to achieve what I need to do?