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 use slicer for select department.
But If I filter status Department . Department show only status is match.
I want to show department all not change.
Please guide me.
Solved! Go to Solution.
Hi, @Anonymous
I agree with amitchandak. You can turn on the Edit interaction in Format tab, then select the Slicer and click None on 'department' visual to turn off the interaction with department', then the department' will not be filtered by 'status' from Slicer. Maybe you need turn off the interaction from the red section in your report to the 'department' as well.
The result looks like this:
Best Regards,
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
I agree with amitchandak. You can turn on the Edit interaction in Format tab, then select the Slicer and click None on 'department' visual to turn off the interaction with department', then the department' will not be filtered by 'status' from Slicer. Maybe you need turn off the interaction from the red section in your report to the 'department' as well.
The result looks like this:
Best Regards,
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , not very clear. But you can switch off interactions
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
1. I choose department from slicer (In left side)
2. choose slicer for filter status (in drobdown right side)
3. It filter status , If status = delete , So some department from slicer appear.
I want to show department all.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |