Changing date look back when using field parameters?

[pbimhkc]

I have a stacked column chart that is summing an account balance on the y-axis with the date as the x-axis. I am using field parameters with both axes, with the x-axis having a toggle to group the account balance sum either daily, weekly, or monthly. This is working mostly as expected however I want the date lookback to be dynamic based on the field parameter chosen. By default it is going back 7 days when days is selected, 12 months when months is selected, and 13 weeks when weeks is selected. I would like it to go back 5 weeks when days is selected, 6 months when weeks is selected, and 13 months when months is selected. Is this even possible? Thank you

[amitchandak]

@pbimhkc , for that you have to switch measure with the axis

refer this example

Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f

But if select a date you can not get more than that on axis for that slicer needs to be on independent date table

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

Deal with Period

https://medium.com/chandakamit/power-bi-when-i-felt-lazy-and-i-needed-too-many-measures-ed8de20d9f79