How to change type of date aggregation according to filter?

[Anonymous]

Hi everyone!

I have relative date filter for my report and I want to change date aggragation according to what time frame is selected in the filter pane.

For example: when I choose last 1 week I want to ilustrate data by day, and when I select last 1 year I want to show data by month.

Is it possible in Power BI?

[amitchandak]

@Anonymous , I think you want a dynamic axis. Refer

Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/

[mpicca13]

@Anonymous to my knowledge, this dynamic behavior is currently not available. A workaround would be to used bookmarks or drill-throughs.