Forum Discussion
multiple slicers for two visuals
I have 5 slicers and 2 visuals on a report. I want 5 slicers to apply to Visual1 and 4 slicers to apply to Visual2. Visual2 will have the 5th field hardcoded and should not use the slicer. The instructions seem straightforward, but I cannot get visual2 to ignore slicer5.
Here is the screenshot for the visual1 setup.
- Visual1 is selected
- Visual1 will use all 5 slicers (red outline1)
- Visual2 will ignore changes to Visual1 (red outline2)
- This works, all slicers control the appearance of Visual1
Here is the screenshot for the Visual2 setup
Visual2
- Visual2 is selected
- Visual2 will ignore the slicer labelled _type_ (red outline3)
- Visual1 will ignore changes to Visual2 (red outline4)
- Visual2 is filtered to show only _type_=1011
- This does not work. Visual2 is displaying the _type_ shown in the slicer.
What am I missing?
Outline3 means that you are preventing Visual2 from filtering _type_ slicer. You are correct for Outline4.
A slicer is just another visual, so the controls are not reversed for these. It works the same as one matrix filtering another matrix. To prevent a slicer from filtering a matrix, you need to click on the slicer and click the 'do not filter' icon for the matrix.
4 Replies
I think you might have your controls backward. In order for _type_ slicer to not filter Visual2, you need to click on the _type_ slicer and turn off filtering on Visual2.
What you currently have is that Visual2 won't filter _type_ or Visual1.
It is my understanding that the filled in 'do not' in outline3 means that Visual2 will not use the _type_ slicer and that the filled in 'do not' in outline4 means that Visual2 will not honor any selections in Visual1.
Currently, Visual2 seems to be 'anding' both the _type_ slicer and the hard-coded filter inside Visual2.
Thoughts?
Outline3 means that you are preventing Visual2 from filtering _type_ slicer. You are correct for Outline4.
A slicer is just another visual, so the controls are not reversed for these. It works the same as one matrix filtering another matrix. To prevent a slicer from filtering a matrix, you need to click on the slicer and click the 'do not filter' icon for the matrix.