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?
