Forum Discussion
Visual
Is there a way in Power BI to apply filters to an entire page but prevent those filters from affecting a specific visual?
For example, I have a report with multiple page-level filters and a slicer visual. Currently, all the page filters are also applied to the slicer, which I do not want. I am open to using a different visual if needed. Does anyone have any suggestions on how to achieve this?
Also, which visual can be used if you do not want “Filters on this page” to affect a particular visual?
Hi Mon_0Pun,
You need to use the measure in your visual and not as slicer or visual filter. If you are using sematic model or a live connection you should still be able to create a table n top of it.
I've created a sample .pbix file showcasing the page level filter, Edit interaction and Visual level filter without creating a new table. hope this clarifies how you cn inplement the same.
8 Replies
Move your logic from page filters → slicers, then use:
Format → Edit interactions
- Select the slicer
- Turn off interaction for the visual you want to ignore the filter
This gives you full control per visual.
Hi Mon_0Pun
Thank you for reaching out to the Microsoft Fabric Forum Community.
InsightsByV danextian grazitti_sapna cengizhanarslan Thanks for the inputs
I hope the information provided by users was helpful. If you still have questions, please don't hesitate to reach out to the community.
Hi Mon_0Pun
Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.
Hi,
I believe there is no direct way to do this. I have researched a little and found that creating a disconnected table of slicers can be a workaround. You can add measure to make selections work properly.
Hi Mon_0Pun,
There are few ways to achieve this:-
1. You can ignore filters for a particular measure using removefilters, for e.g.
Total Sales (Ignore Page Filters) =
CALCULATE(
SUM(Sales[Amount]),
REMOVEFILTERS()
)2. You can create a disconnected table for the fields like SlicerTable = DISTINCT('Sales'[Category])
and then use it in your final DAX like
Selected Sales =
CALCULATE(
SUM(Sales[Amount]),
TREATAS(VALUES(SlicerTable[Category]), Sales[Category])
)3. You can use edit interaction to stop slics to interact with that particular visual, to do that go to Format → Edit Interactions and then turn off the interaction
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!Thanks grazitti_sapna for the providing the solution. I used your remove filter measure, but I am unable to use that measure in my filter visual. Also my access is restricted to create any table or column.
Hi Mon_0Pun,
You need to use the measure in your visual and not as slicer or visual filter. If you are using sematic model or a live connection you should still be able to create a table n top of it.
I've created a sample .pbix file showcasing the page level filter, Edit interaction and Visual level filter without creating a new table. hope this clarifies how you cn inplement the same.
