Loading

Creating a Parameter List with an Option to Filter by All Values

Дата публикации: Feb 23, 2026
Описание
How to create a parameter with a list that includes the option to filter by all parameter values.
Решение

Create the parameter

  1. In the Parameters pane, right-click and select Create > Parameter....
  2. For Data Type, select String.
  3. For Allowable values, select List.
  4. In the List of values add the dimension members of the desired field to be filtered.
  5. Click Click to add new value to manually add the value "All".

Create a calculated field

  1. Navigate to Analysis > Create calculated field....
  2. Enter a formula similar to the following: [Dimension field you want to filter on] = [Parameter created above] OR [Parameter] = 'All').
  3. Drag the new calculated field to the Filters shelf and select True.
Дополнительные ресурсы
This calculation can also be added as a condition in a dimension filter, which is a way to use this solution when connecting to OLAP datasources

More information at Filtering With Parameters Community thread.

For additional workarounds, see the following third party articles:  Create a Multiple Value Selection Parameter
Номер статьи базы знаний

001473816

 
Загрузка
Salesforce Help | Article