Forum Discussion
Ignore filter on visual
Hi guys,
I'm creating a Box plot visual that shows the price distribution of our sales. To do this I am using the orderID on the Axis and price as a value. Which returns the visual below. I have a problem with fitlering though: there is a pagefilter on 'partnername' that I want to ignore. Usually I would use a 'calculate' function with an 'all' filter, however i do not want to sum, count, average etc. for my OrderID. I just want the orderID to ignore the 'partnername' filter.
Can anyone help me with this?
Thanks in advance!
Menno
Hi Anonymous ,
'partnername' filter is a page-level filter. It will add this filter to all page visuals.
We recommend that you change the visual filtering method: you can remove all page filters and then add a separate visual effect filter for all the visuals you want to be affected on the current page, leaving only one visual effect without a filter, and add filters for all other pages on the filter on this page level.
Solved: Need one Visual to ignore a Page Filter - Microsoft Fabric CommunityBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
2 Replies
You can use a Slicer and then play with Edit Interactions so that the visual is not affected but when you add a filter to page Filter there is no way to make this not affect the visual.
Hi Anonymous ,
'partnername' filter is a page-level filter. It will add this filter to all page visuals.
We recommend that you change the visual filtering method: you can remove all page filters and then add a separate visual effect filter for all the visuals you want to be affected on the current page, leaving only one visual effect without a filter, and add filters for all other pages on the filter on this page level.
Solved: Need one Visual to ignore a Page Filter - Microsoft Fabric CommunityBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
