How to use a Category Parameter to set the default values of Sub-Category filter?
The ability to set default values of a quick filter by parameter is currently not built in the product. As a possible workaround use the filter from filter actions. Follow the steps and follow along in the attached package workbook.
1. Create a new worksheet filter action
2. Add Category to Rows, Sub-Category to Text
3. Create a calculation field Category Filter
[Category]=[Parameters].[Category]
4. Add Category Filter to Filters, select True
1. Create a dashboard solution
2. Add worksheet original to the dashboard
3. Add worksheet filter action to the dashboard
4. Hide the title of worksheet filter action
5. Right click row Category, select Hide field labels for rows
6. Adjust the size of worksheet filter action to hide the text of Sub-Category
7. Select from menu bar Dashboard > Actions
Add Action > Filter...
Create a filter action like the following:
8. Click the category text in worksheet filter action
9. Click More Options from worksheet Original, select Filters > Action (Sub-Category)
10. Confirm default values are set correctly in Filter Action (Sub-Category)
001458373
1238 KB

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.