Forum Discussion
Helper IIDynamic Date Axis Based on Period Slicer (Day, Week, Month Granularity)
Community SupportHi BJankic ,
If your issue is resolved, that's good. If you need any further assistance or additional details, feel free to let me know.
Thank you.
Helper IIHi V-yubandi-msft,
The issue still isn’t resolved. There has to be a way to handle this with parameters and switch the X-axis to different date views, right?
- V-yubandi-msft
Hi 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.
- BJankic
Hi 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.