Hide values in Filter

Question & Answer
, , ,
1

I have a filter - Metric which has say 5 metrics- A,B,C,D,E. I would like to show the user only the value A,B,C,D and hide E completely from the filter. How can this be done?
This can be done in Tableau easily by adding a context filter and I have been struggling to achieve the same here since the past few hours.

I have around 35 metrics and I do not want to create a parameter and use it as a filter because it is time consuming and not dynamic when I add new metrics.

2

Hi @Rishita_Chebrolu

QuickSight does not currently support hiding specific filter values (like E) directly within a filter control. Please try the following workaround.

  1. Create a calculated field (e.g., VisibleMetric) like.
ifelse({Metric} = 'E', NULL, {Metric})
  1. Add this VisibleMetric field as a filter and exclude NULL.
  • This hides E from filter dropdown.
  • Works dynamically when new metrics are added, as long as they’re not ‘E’.

I will mark this topic as a feature request.

Please refer the below community post this might be helpful for you.

3

Hi @Rishita_Chebrolu,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

4

Hi @Rishita_Chebrolu,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you!