Forum Discussion

frankhofmans's avatar
frankhofmans
Helper IV
2 years ago
Solved

Dynamic date filter in graph

hi all,   i have a dashboard with a lot of bar graphs with the date (from a date table with day, week, month, quarter, year) on the X-axis and value on the Y-axis. You can switch from year to quart...
Need Help
  • Uzi2019's avatar
    Uzi2019
    2 years ago

    Hi frankhofmans 

    I implemented same fo my client usinf field parameter. please follow these steps:
    Step1: Go to modeling tab > select field option

     

    step2 : give Parameter name to X Axis > Drag and drop year, month qtr, date from right side to the left side.

    Click create.


    Step3: New slicer is added on page.

     

    steps4:  take your X axis value in Line chart X Axis.


    step5: change slicer format  to tiles. and if dont want any hierarchy change it to single select.


     

    I hope this would work for you.

     

     




Uzi2019's avatar
Uzi2019
Community Champion
2 years ago

Hi frankhofmans 

I implemented same fo my client usinf field parameter. please follow these steps:
Step1: Go to modeling tab > select field option

 

step2 : give Parameter name to X Axis > Drag and drop year, month qtr, date from right side to the left side.

Click create.


Step3: New slicer is added on page.

 

steps4:  take your X axis value in Line chart X Axis.


step5: change slicer format  to tiles. and if dont want any hierarchy change it to single select.


 

I hope this would work for you.