Forum Discussion

AutyDA's avatar
AutyDA
Icon for Helper I rankHelper I
2 years ago
Solved

Change axis Date Hierachy based upon a slicer

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 possibl...
Need Help
  • danextian's avatar
    danextian
    2 years ago

    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's avatar
    AutyDA
    2 years ago

    Thank you, that worked!

AutyDA's avatar
AutyDA
Icon for Helper I rankHelper I
2 years ago

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?