Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Is there anyway to remove the page level filter for just 1 visualization?
For example I have a card visualization that displays the count for November of data i am working with. The whole page has a page level filter where date >= 11/01/2016 and is < 12/01/2016
If i want another card visualization to display the count for October data, how can i do this ? I basically don't want the page level filter to apply to just this one visualizations..
Thanks!
Hi @lasthero,
You can try measurements on these visuals that cancel the filtering done by page or report-level filters, like so:
ID_all = CALCULATE(DISTINCTCOUNTNOBLANK(Table[ID]),ALL(page_filter),ALL(report_filter))
So all the other visuals can use the Table[ID] column, for those that you want to remove filtering, you can use ID_all.
Please mark as solved if you find it useful.
Best,
Leo
Thanks, this code works! 🙂 🙂
ID_all = CALCULATE(DISTINCTCOUNTNOBLANK(Table[ID]),ALL(page_filter),ALL(report_filter))
To give you more insights on this, Page level filters are like slicers and you can also edit the interactions between slicers, you can do so by using edit interactions option.
This will allow you to customize your report as you would like.
Hi Bhavesh,
Thanks for the reply, i understand normally how to edit interactions with the slicer or any other visualizations, however I can't seem to find how do i edit an interaction with a page level filter?
Thanks
Scott
Hi @lasthero,
Page level filter means it filters every visual on the page, and it is not allowed to edit the interaction. To work around your issue, you can add visual level filter or use sclicer to filter the specific visual depend on your need.
Thanks,
Yuliana Gu
Don't think this is possible as you are applying a page level filter which applies to the whole page. You could add in a regular date filter and then when its selected go to format/edit interactions and specify which visuals you want that filter to interact with.
Move the visualization to a different page. Page Level filters, by definition, filter everything on the page. Add in another page and put your new visuals there. If you need to see them side-by-side later, you can create a Dashboard view.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
105 | |
99 | |
99 | |
38 | |
37 |
User | Count |
---|---|
157 | |
121 | |
73 | |
73 | |
63 |