KNOWLEDGE BASE

Preventing the Selection of Multiple Values in an Interactive Filter When the Dimension is Also Used in a User Filter


Published: 12 Jul 2021
Last Modified Date: 13 Jul 2021

Question

How to prevent the selection of multiple values in an interactive filter (also known as a quick filter) when the dimension is also used in a user filter

Environment

  • Tableau Desktop
  • Tableau Server

Answer

  1. In Tableau Desktop, ensure that the dimension filter selection is for all values.
  2. Click the drop-down menu on the filter card, and select one of the Single Value modes (List, Dropdown or Slider).
  3. Click the drop-down menu on the filter card, select Customize, and click on Show "All" Value to deselect it. 
  4. Publish the visualization to Tableau Server.
  5. Embed the view into a web page, and append to the URL a query string that is not a valid filter value, e.g.:
http:<servername>/#/views/Userfiltertest/SalesbyProduct?Category=Pick%20a%20value


Note: The embedded view would load without any data displayed initially, and the viewer will need to pick a value in the interactive filter. For example:

User-added image

Additional Information

  • If only one of the dimension members is selected in the interactive filter when the visualization is published, users who do not have access to that member will not see any data in the visualization, and they will not be able to change the value of the filter.
  • When the dimension filter selection is for all values, and the base URL is used, users who have access to multiple members of the dimension will see a view that includes data for all these members.
Did this article resolve the issue?