As of now this feature is not available in tableau.
There is an Idea you can vote there https://community.tableau.com/ideas/1178
there is workaround for this by accessing the dashboard using java script API
or if you are using tableau 2018.3
check this extension
Hope this helps.
Plz mark this answer as correct or helpful to close the thread
Thanks for replying.
Unfortunately I'm on 10.5 and can't use the extension mentioned.
The issue I'm facing is, we have a report data for which gets updated on weekly basis. We have the report designed to show numbers on week on week basis. Now due to the screen size we have limited the view as 14 weeks to be displayed but have given the control to the user to scroll through previous weeks using the slider (integer parameter). Also, I want to restrict the user to be able to select week as week 1 till current available week as I don't want the sheet to go blank if the user select any future week.
I tried the below approach:
- Created an integer parameter "View from Week" with starting value as 1 and maximum value selected from using "set from field".
- created a calculated field with formula "[Fiscal Week Number] >= [View from Week] and [Fiscal Week Number] <= [View from Week]+13" to show the 14 weeks from the week number selected by user
But the issue with this approach is, as the new data will come through every week the maximum week number value in Parameter does not get updated automatically depending on the field value.
Not sure how i can achieve the required functionality.