We are trying to display about 10 filters and all filters need to be shown along with other dimension values as count.
We need here only multiselect filters with check box only. Not using actions.
For this, I used calculation field with dimension and concatenated with count using FIXED LOD and only relevant values for all filters. When I do this initial filters values working fine. But when I select values in filters then filters are disappearing and some filters shows all values but checked with few options only.
Attaching screen shots.
Screen shot 1: Initial dashboard. Looks good
Screen shot 2: When I select category = furniture then all filters and sheets corresponding data. Looks good for now.
Screen shot 3: When I select state = Alabama then filter 1 category disappears. This is issue
Hi @Venkat Ganta
If you don't want the values to not show when another filer is checked, you should not use relevant values only else you're gonna get your screenshot 3. If some filter should, you can put them in Context and the choose All Values in Context instead.
Hope it helps,
Viviane
_ _ _ _
Please mark as Select as Best if this resolved your question, or Upvote if it helped.
