Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Slicer filter with time interval based on slicer selection

Hello everyone,

 

Sample of data:

ID Date myValue

1 1/09/2019 7

2 1/09/2019 3

3 2/09/2019 2

4 3/09/2019 5

5 4/09/2019 2

 

I need to create 3 slicers:

   -   The first one gives the possibility to choose a specific date ( date picker), I set the date range to Before.

   -   The second one gives the possibilty to choose the previous time interval (day, week, month, quarter or year) based and from date that is selected on the first slicer

   -   The third one gives the possibilty to choose resolution on the x axis. Example if you chose year as time interval on the second slicer, then you can choose the resolution on x axis from day, week, month or quarter

So far all I could achieve is creating some dynamic measures that change the resolution but no succes with making time intervals.

 

Has somebody tackle this problem before?