Change axis Date Hierachy based upon a slicer

[AutyDA]

Hi,

I have a series of data which at times I show annually and at times quarterly. I would like the Date Hierachy to change from Year and Quarter to just Year based upon a slicer. Is this possible?

Thanks,

David

[danextian · Accepted solution]

Hi @AutyDA 

If you really want to show year and quarter as a hierarchy and be able to change the hierarchy order with a click of a button, your best shot is with bookmarks. Otherwise, you can use field parameters to switch between columns but only one at a time and not a hierarchy - year and quarter column to quarter and year and vice versa.

Please see sample pbix

[AutyDA]

Hi,

I've come back to review this and whilst the solution works the chronological order on the dates gets lose on the dates axis. For example in you chart below 2024 Q1 is followed by 2023 Q1 then 2023 Q2. How can I maintain the chronological order?

[AutyDA · Accepted solution]

Thank you, that worked!

[danextian · Accepted solution]

Hi @AutyDA 

If you really want to show year and quarter as a hierarchy and be able to change the hierarchy order with a click of a button, your best shot is with bookmarks. Otherwise, you can use field parameters to switch between columns but only one at a time and not a hierarchy - year and quarter column to quarter and year and vice versa.

Please see sample pbix