3 of 3 people found this helpful
This can be done based on the calculation that is created with the parameter. For example, using the Superstore data, if every value for Category should show Furniture, then the parameter should list out all the values in Category (Furniture, Technology, Office Supplies). Then, a calculation similar to the following should be created:
when 'Office Supplies' then (if [Category]='Office Supplies' or [Category]='Furniture' then 'show' else 'hide' end)
when 'Technology' then (if [Category]='Technology' or [Category]='Furniture' then 'show' else 'hide' end)
when 'Furniture' then (if [Category]='Furniture' then 'show' else 'hide' end) end
Place this calculation on the filter shelf and check only 'show' on the resulting box. Then, show the Parameter Control.
Hope this helps!
1 of 1 people found this helpful
I have the exact same question, except I need to make sure that all of the filter options are still working - so the parameter solution won't quite get me there. In my case, I need to be able to have user still select multiple options from quick filter, but null values in a field to never be filtered, regardless of what combination of other items are selected from the quick filter interface.
Ideally, it would look like the subject of this thread suggests - hiding/customizing which values appear on the quick filter.
I ran into the same problem now. Its been long but have you found out a workaround to this activity?
I have the same doubt as Justin's and Varun's. If you guys have figured out any work around, would be highly interested to know that.
Hi! I'm still having the same problem of Dan Koors and already is not solved.
Same problem, any news? Thanks