Dynamically change x axis for Month Quarter and Year

[Sage2019]

Hi ,
I am trying to achieve changing the x axis to view sales by month, quarter and year depending on the slicer selection. How could I achieve this using bookmarks or field parameter? 

[olgad]

@Sage2019 Have my answer solved your problem? If so, can you please accept my answer as Solution to help other members find it faster? Thank you very much for your kind cooperation!

[Joerg-Oliver]

Generally the solution works, I did the same. However, I am facing challenges with the Sorting. Each time I change the x.axis the visual switches to sort the y.axis decending. I can manually change to sort the x.axis ascending but at the moment when I toggle from month to year (or any other thing) the visual moves back to sort the y-axsis
Any thoughts?

[olgad]

Hi @Joerg-Oliver , yes this is a known problem. What you have to do is to make sure that all the columns used in the parameter are sorted. EXample: I pick monthly, and the sorting of months gets alphabetical. I need to sort the column month by the number column, or if i have Jan 2024 column i need to have a corresponding 012024 column, to sort it. Then you sort correctly on the visual one more time and then it works.

[olgad · Accepted solution]

Hi, create a field parameter-modelling-field parameter, drag three separate fields year, quarter month (you can drag here yearmonth column if you need 202305/ May 2022,not simply month)-ok. add it as a slicer. Add the parameter to your vizualization. Right click in the viz pane x-axis field parameter-Show values from selected fields.