Hi All,
I want to create below buttons in dashboard based on date variable.
In date variable we have date formate is dd-mm-yyyy.
Now here i want to create a dashboard in which based on above buttons selection i want to display specify sheets(like sheetA for overall, sheetB for Quarter, and so on.
Thanks in advance.
Hi Rahul,
Once they select a different date period, eg. Quarter, are you hoping to allow them to choose a specific quarter? Or is it always most recent. Curious.
You can go about this a few ways.
1. The filter action as described in the response above.
2. Navigation buttons: duplicate the dashboard per as many buttons. Upon selecting Quarter, go to the Quarter Dashboard.
3. Parameter actions. Create a new dataset with the options for the buttons. Then create a filter to decide which sheet to expand in a horizontal container. You could technically do all of this in one sheet, however, in order to allow the user to change the date selected, it was easier to break these up into multiple sheets, format the date filter per each sheet (quarter, month, week), and have it filtered to "most recent available".
The other trick is to have collapsing sheets that push out the date filters per sheet. Hope the attached workbook proves useful!
Best,
Bryce
