Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |