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.