Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Here is the screenshot for the Visual2 setup
Visual2
What am I missing?
Solved! Go to Solution.
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.
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.
You are correct. That fixed my problem. The _type_ slicer is just another visual. Click on the _type_ slicer and then click on the 'do not' icon so that Visual2 is not filtered based on the _type_ slicer.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |