Can we sync filters in 2 different sheets

Question & Answer
, ,
1

I wanted to know if there was any way to sync filters in different sheets
So when we filter one sheet the same filter should be applied to the different sheet.

Can somebody help me with this

2

Hi @Vysh27,

you can use a parameter for that.

  1. Create a parameter
  2. create filter for a visual
  3. “use parameter”
    grafik

If you do so, every filter linked to the parameter will updated as soon as you change the value.

BR

1 Like
3

Hey @ErikG I’m trying out this approach but it doesn’t seem to workout

could you share the detailed process or any links related to it

4

What doenst work?

Sheet 1:
Parameter = pDevice
Filter for visual with equals = pDevice
Filter Control for pDevice

grafik
grafik1315×598 23.7 KB

Sheet 2:
Filter for visual with equals = pDevice
opt. Filter Control for pDevice

grafik
grafik1035×570 31.8 KB

BR

1 Like
5

It’s working
Thanks @ErikG !

2 Likes
6

@ErikG is there any way we can give multiselect option to the paramter controls?

7

Hi @Vysh27
you can create a multiple values parameter.

BR