How To Make Filter Actions Work For Measure Names Using Parameter

Udgivelsesdato: Apr 13, 2024

Opgave

Is it possible to use a measure (instead of dimensions) as a source for filter action?

Trin

Build the Details crosstab
1. Create a new worksheet Details
2. Create a parameter Measure Names Parameter as the following:
3. Create calculation field Selected Profit
```
if [Measure Names Parameter]="Profit"
then [Profit]
END
```
  Create calculation field Selected Sales
```
if [Measure Names Parameter]="Sales"
then [Sales]
END
```
4. Drag Order Date to Columns
5. Drag Measure Names to Filters card, select Selected Sales and Selected Profit
6. Drag Measure Values to Text in Marks card
7. Drag Measure Names Parameter, Category, Sub-Category to Rows
Set up dashboard actions
1. Create a dashboard, add Bar Chart and Details to the view
2. Select from the menu bar, Dashboard>Actions...>Add Action>Change Parameter
3. Click the Use as Filter button of the Bar Chart
4. Edit the generated filter, change the Clearing the selection will: to Exclude all values