How to hide values from a filter in QuickSight?

Q&A
, ,
1

I’m creating a filter based on a region column, but this column contains NULL values. When I build the filter, I don’t want users to see or select the NULL option. How can I restrict the selectable values in the filter without affecting the existing components of the report?

image
image142×219 7.73 KB

2

Hello Chan,

you may use custom filter list control -

  • Click on the filter control

  • Go to “Filter type” settings

  • Select “Custom list”

  • Manually select only the non-NULL values you want to display in the filter

image
image227×446 6.03 KB

Hope this helps.

Cheers,

Deep

3

Thank you very much!

I have successfully excluded NULL values. For example, if I want to exclude a few specific values so that users cannot see them, is that possible?
Keep in mind that my list of values is very long and can change frequently, so I can’t hardcode the values.

image
image235×661 15.8 KB

4

Hi @chanhlm , there are several ways to do it.

You can create a parameter and another dataset with filtered out values that will be shown in the Region dropdown.

You also can create another Exclude filter with a visual and use “Relevant value” to set dependencies in order to exclude the selected values from the Region dropdown. Then you can hide this Exclude filter or make it as small as possible… depends on your layout.

5

Hello Chanh,

Yes as Hrolol mentioned there are ways to do, you could also create calculated field that already restricts unwanted values and use that field as filter.

you are correct if you have too many values custom filter may not be appropriate to use.

Hope this gives some idea.

Cheers,

Deep