Get filter selection values as text

[jemin]

The dashboard has multiple filters (>10) and a few visuals, the stakeholder wants to see at the top a list of the values selected in the filter.
ex:

Filters - Country (All), Age (All), Gender (All)

TOP VISUAL should look like

Filters Selections:
Country - All
Age - All
Gender - All

Filters changed
Country (All), Age (18-24, 35-54), Gender (M)

TOP VISUAL should look like

Filters Selections:
Country - All
Age - 18-24, 35-54
Gender - M

This will help them to take screenshots and make it easier to figure out later what the filter selections were for the actual data charts.

One option is to create multi-select parameter for each filter and use it in a new visual’s header… but if more than 2 values are selected it shows as – a, b and 2 more…

[jose_burrull]

@jemin … you can create 3 parameters for Country, Age and Gender and put them as controls above the canvas, as controls.

Then, you create a custom visual content as following:

Then copy the next URL, changing it for your own parameters and limiting the number of items, if they were a lot.

https://d3mcm3b4p172iv.cloudfront.net/filters_no_header.html?Campo homologado=<<$Homologado>>&Campo version=<<$Version>>&Campo param1=<<$p1>>&maxItemCount=10

So, you get :

Regards,
José Miguel Burrull
Senior Data Engineer at Itvis Spa. Santiago de Chile . Dec.12, 2023

[Wakana]

hi @jemin

just to add to what @jose_burrull said
we have demo dashboard for it : https://democentral.learnquicksight.online/#Dashboard-TipsAndTricks-Interactivity-Display-Selected-Filters.

kind regards,
Wakana

[jemin]

Thank you so much @jose_burrull for the suggestions.

And @Wakana , from the first looks your demo dashboard is exactly the thing I was looking for!! Thank you for sharing… I knew about Parameter but didn’t know how to use them.

I still don’t understand the url part - how do I generate the url for filters and add custom text per my use case in there?

[robdhondt]

If you’re using Amazon QuickSight’s custom visual content to display selected parameter values and want more customization, you might be familiar with the demo provided here: Display Selected Filters Using Custom Visual Content, which uses this hosted page: filters_no_header.html.

An open-source solution is now available that offers enhanced customization options:

• Hosting the webpage in your own AWS account
• Choosing between a pill-shaped display or the original table look
• Adjusting wrapping or new line options
• Changing pill colors
• Deploying via AWS CDK or CloudFormation template

Check out this open-source repository that has these enhancements: https://github.com/yeahthisisrob/quicksight-custom-parameter-display.

Examples: