Forum Discussion

BJankic's avatar
BJankic
Icon for Helper II rankHelper II
1 year ago

Dynamic Date Axis Based on Period Slicer (Day, Week, Month Granularity)

Hi, I'm working on a report where I want to dynamically change both the time frame logic and the X-axis granularity based on a user-selected period from a slicer. Link to the file: Sample    I hav...
Need Help
V-yubandi-msft's avatar
V-yubandi-msft
Icon for Community Support rankCommunity Support
1 year ago

I tried using calculation groups, but they didn’t work as expected. It seems bookmarks are the better option, so I’ll set that up and share it with you once it’s ready.

 

Thanks for your patience.

BJankic's avatar
BJankic
Icon for Helper II rankHelper II
1 year ago

Hi V-yubandi-msft ,

 

Thank you for your effort, but this isn’t quite what I was expecting. First, I wanted to avoid using bookmarks. Second, you can see that it’s not performing as expected, for the rolling 12 months, it should be comparing periods rather than showing them all in a single line chart. The same applies to the other timeframes as well.

Best regards,

Bojan