Dynamic X axis for next level in hierarchy

Hi All,

I am looking for a way to create a dynamic x axis, which gives us the ability to filter next level in hierarchy as per selection on other visuals.

For example:

I have visual1 which is a bar chart with X axis as Date hierarchy(Year,quaters,months,day)

I have visual2 which is a bar chart with X axis as Date hierarchy and Week numbers

If I click on 2022 Year in the visual1 bar chart, my visual2 should show X axis as months

If I click on Jan Month 2022 Year in the visual1 bar chart, my visual2 should show X axis as Week numbers

How to get this done dynamically ?

I hope I was clear with my question. I dont think field parameters will help us here, because I want to select the next level in the hierarchy.