Forum Discussion

lizardi89's avatar
lizardi89
Helper I
6 years ago

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...
Need Help
v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

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.

lizardi89's avatar
lizardi89
Helper I
6 years ago
Hi Lionel,
Thank you for your help, would there be any way to fix the model to achieve what I need to do?
  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi lizardi89 ,

     

    For your problem, we can't solve it by modifying the model. Maybe you can do like this:

     

    1. Creating a [Range] column in Contracts table:

    Range = 
VAR x = TODAY()
RETURN
 [Signature Date] & "--" & x

     

     

    2. adding a slicer:

    Doing like this also enables dynamic changes.

     

    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.