Create a filter to choose the values/metrics fields in a pivot table

Question & Answer
, , ,
1

Hi!

I have a Pivot table dashboard in Quicksight with 20 values fields (metrics). I want to create a control where users can choose specific fields they want to see on the dashboard (multi selection control). Example: Choose 4 out of these 20 values fields (metrics). Is it possible in quicksight?

I have created a control with a parameter but it only allowed me to choose one value field and in the dashboard does not appear the name of the chosen metric, appears the name of the parameter. If viewers choose 4 values fields out of 20, I would like them to see the name of each metric selected in the dashboard.

Thanks a lot in advance!

2

Hi,

Thanks for reaching out. This can be done, but you’ll need a parameter for each of the fields. See this post for a solution. https://community.amazonquicksight.com/t/dynamic-selection-of-dimensions-in-pivot-table/2793/3

Best,
Sean

1 Like