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

Hi BJankic ,

Thank you for reaching out to the Fabric Community. I noticed that your sample file needs access permissions, so I couldn’t view your data directly. To assist, I recreated your situation with sample data and was able to achieve the dynamic time frame and axis granularity you mentioned.

 

I’ve attached a PBIX file for your reference. Please take a look and let me know if you need any changes. I’m happy to help further.

 

Best regards,

Yugandhar.

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

Hi V-yubandi-msft , I’ve now allowed access to everyone with the link. However, this is not the solution I’m looking for.

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Icon for Community Support rankCommunity Support
    1 year ago

    Power BI does not currently allow you to dynamically change the X-axis granularity (such as day, week, or month) and values directly through a slicer. As an alternative, you can use bookmarks to switch between visuals with set granularities, though this approach may not provide complete dynamic axis control.

    Thanks&regards,
    Yugandhar.