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!

danextian's avatar
danextian
Icon for Super User rankSuper User
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