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?
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
Hope this helps.
Cheers,
Deep
1 Like
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.
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.
2 Likes
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
1 Like