Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
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
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.
Move your logic from page filters → slicers, then use:
Format → Edit interactions
This gives you full control per visual.
Hi @Mon_0Pun
The only way to do this is if the dimension used in the visual isn't anyway related to the filter dimension.
Please see thea attached sample pbix.
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.
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.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 55 | |
| 40 | |
| 35 | |
| 19 | |
| 18 |
| User | Count |
|---|---|
| 71 | |
| 70 | |
| 38 | |
| 35 | |
| 23 |