Hi all,
How do I make a filter control only affect the elements of the same sheet? It´s the same control for several sheets, it´s configured as “Some visual elements” I selected the elements of that sheet, but when I change that control, it changes the same control of the other sheets and changes the information. For example: the control “country”, if I select Mexico in the first sheet, in the second sheet it is also selected in Mexico.
Do you know if you are working with filter control or parameter control? (Note that parameter controls can be used to filter data as well. The way to check it is open the analysis and click “Edit” on the control. If it is a parameter control, you will see this at the top of the dialog
If it is a filter control, you will see
)
Parameters are global, so when you change value of a parameter, it will be used by all sheets, all calculations etc.
Filters are NOT global. If you change filter value on one sheet, it will not impact visuals on the other sheets.
If you do use parameter control, you probably want to move and use filter control instead.
Thank you very much for your help