Urgent_Custom filter names that change depending on the selected category

Question & Answer
, ,
1

Hello,

We are trying to figure out if we can set custom filter names that change depending on the category you select.

We are looking to change the names of the spec filters at the top to different names depending on the parent product selected

For example (As seen in attached screenshot) :

If we select “Refrigerators” We would want spec_filter_1 to say “Capacity”
If we then select “Dishwashers” we would want spec_filter_1 to say “Cycles”
Same dataset, same fields, just looking to change the name of the filter only

image (11)
image (11)1615×320 36 KB

Regards,
Nikhil.

2

Hi @Nikhilburhade,
Unfortunately, there is not a feature that allows you to dynamically set the parameter/filter titles based on the selection of another parameter/filter.
One workaround you could explore (depending on how many options you would have for the second control), would be to create a parameter for each of your secondary control(s)…‘Capacity’, ‘Cycles’, etc.
Then setup rules for each of those parameters that show each one depending on what your parent parameter is set to (you would set them to be hidden by default so that you can’t see them in dashboard view).
I setup a brief example of how you can achieve in Arena view:
Urgent_Custom filter names that change depending on the selected category

Let me know if you have any additional questions!

1 Like
4

Hello @Brett,

Thank you for your suggestion.

I explored a different approach to dynamically update filter titles in QuickSight and wanted to share how it worked out.

image
image1237×171 11.2 KB

I first created a dropdown control for Parent Product, then built calculated fields (spec_filter_1_label to spec_filter_6_label) using ifelse logic based on the selected value. Each calculated field is used in a small table visual placed above its corresponding filter. I cleaned up these table visuals by hiding unnecessary headers and formatting them for a minimal look. Using free-form layout, I aligned each label with its filter to create a seamless and dynamic interface.

Here’s an example of the ifelse logic used in the label:

ifelse(
  {Parent Product} = 'Refrigerators', 'Capacity',
  {Parent Product} = 'Dishwasher', 'Cycle',
  'spec_filter_1'
)

Let me know your thoughts!