Cascade filtering

Question & Answer
,
1

Could you walk me through step by step how to create cascade filtering? I read several answers , but still couldn’t apply it. Really frustrating…
Also, how can I apply filters to all tabs (same and different data sources)?

Thank you,
Olga.

2

Hi @olga1
maybe the following will help.

BR

1 Like
3

Hi @ErikG ,

I saw this one, but I think it’s an old version and doesn’t apply anymore.

Thanks,
Olga.

4

Hi @olga1
no what @Biswajit_1993 wrote is pretty much what you have to do.
BR

5

Cascade filter:Filters have the option to use “Show only relevant values”. But the filter with relevant values need to be added to the dashboard as well.

Screenshot_2024_0123_233050
Screenshot_2024_0123_2330501055×672 167 KB

6

Okay, I can’t find the control option

image
image836×792 55.8 KB

7

Add filters to the sheet then you click three dots then you can see the options.

Screenshot_2024_0123_235430
Screenshot_2024_0123_235430282×608 35.8 KB

8

Thank you! So I can’t do it unless I place the filter on the sheet? so for example, if I pin it to the top?

9

Yes.
If you don’t give the users the ability to change the filter, why using a cascading filter?

10

I can place the filter on top, but than I don’t have the pencil option

11

What about the three dots?

12

I have the 3 dots, but it doesn’t allow me to do the cascade filtering
image

13

Click on ‘edit’ and follow ‘step1’ of the topic I posted earlier.

14

Thank You Erik!
I totally missed it

15

Hi @olga1
could you solve your issue?
if so, could you also mark the post as solved?
BR

1 Like
16

Yes, I was able to solve it, thanks!
How do I mark the post as solved?

1 Like