Forum Discussion
Helper IIDynamic Date Axis Based on Period Slicer (Day, Week, Month Granularity)
Helper IIHi V-yubandi-msft,
Thanks for clarifying. Let’s try the calculation based approach.
Best regards,
Bojan
Community SupportHi BJankic ,
Thank you for your patience. I’ve reviewed the solution and made some updates it’s now functioning properly without bookmarks. I hope this aligns with your needs.
When you have a chance, please review the attached PBIX file and let me know if it works for you or if any further changes are required.
Best regards,
Yugandhar.
- BJankic
Hi V-yubandi-msft ,
Thank you for your effort, but unfortunately it is not working properly.
First thing X axis should show like this (days, weeks, months) for selected period :
MTD vs. Last Year MTD → show by days
QTD vs. Last Year QTD → show by weeks
Current YTD vs. Prior YTD → show by weeks
Rolling 90 days → show by weeks
Rolling 12 Months → show by months
Second, you have overlaps in terms of the years in the view and time frame is staying the same.
- V-yubandi-msft
Thank you for staying engaged and sharing your concerns.
I understand that this issue might require a more detailed, hands-on approach. While we've covered several possible solutions, I recommend reaching out to a certified Power BI partner for support tailored to your specific needs.
Power BI Partners – Power BI Partners | Microsoft Power Platform
- V-yubandi-msft
Hi BJankic ,
I wanted to follow up to see if you were able to reach out to the Power BI partner community we recommended earlier. If you have any updates or responses, please share them here, as they may benefit other community members.
Regards,
Yugandhar