Forum Discussion
Helper IIDynamic Date Axis Based on Period Slicer (Day, Week, Month Granularity)
Community SupportHi BJankic ,
You're correct this can be done in Power BI using Field Parameters. Although Power BI doesn't let you change the X-axis granularity directly with a slicer, you can use Field Parameters to switch between different date fields such as Day, Week, or Month, depending on your selection. This way, you can dynamically adjust the X-axis in a single visual.
Helpful Reference: Use report readers to change visuals - Power BI | Microsoft Learn
Thank You.
Helper IIHi V-yubandi-msft , okay, can you add that option to the sample I shared?
- V-yubandi-msft
Before I begin updating your file, I want to clarify your expectations. When you mention switch the X-axis to different date views, are you looking for it to automatically change between day, week, and month based only on the Period slicer selection? Or is it acceptable for the user to use a separate Field Parameter slicer to control the view?
Thank You.
- BJankic
Hi V-yubandi-msft ,
Yes, one slicer, to automatically change between day, week, and month based only on the Period slicer selection.
Thank you!- V-yubandi-msft
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.