Example – Change the Limit Values Setting for a Dashboard Filter

This example shows how to configure the Limit Values setting for a dashboard filter.

In this example, you have a bar visualization showing Sales by Product Sub Category.

Description of the illustration filters_limit_values_example_sales_by_product.png

You add a canvas (unpinned) filter by dragging the City column to the filter bar.

You create a dashboard filter and drag the following columns to it to create two dashboard filter controls:

• Product Category
• Product Container

The Limit Values By setting for the filter bar is set to Default. The Limit Values settings for each of these three filters is also set to Default.

Next, you change the Limit Values for Product Container from Default to Auto and None to see how that dashboard filter is affected each time.

Here's what happens if you change the Limit Values setting for Product Container to Auto:

• The values available to select from for Product Container are limited by the selections you make for the canvas filter City and by the selections you make for the other dashboard filter Product Category.
• Select Austin for City. There are only six values available to select for Product Container because the container Medium Box isn't used for that city.
  
  
  Description of the illustration filters_limit_values_example_dashboard_auto1.png
  
  
• Then select Office Supplies for Product Category. The values available to select for Product Container are further reduced to just four, those that are used for office supplies in Austin.
  
  
  Description of the illustration filters_limit_values_example_dashboard_auto2.png
  
  

Here's what happens if you change the Limit Values setting for Product Container to None:

• The values available to select from for Product Container are only limited by the selection you made for the canvas filter City. All six of the Product Containers associated with Austin are now available. Even though you have Office Supplies selected for Product Category, that selection has no impact on the Product Container filter.
  
  
  Description of the illustration filters_limit_values_example_dashboard_none.png
  
  
• It's important to note that in this scenario, while the Product Container filter is limited only by the City filter (because it's in a higher filter location), all three filters still apply to the visualization itself. This means that if you select Jumbo Box, no data displays in the visualization because that product container isn't used for office supplies in Austin.