Forum Discussion
Include and Exclude filter : not a page filter ? only visual filter ?
Dear,
I saw in the MS EDX PBI training that it is possible to remove unwanted information from the report with right-click -> "Include / Exclude" filter.
I tried to replicate but the filter won't affect the other visuals:
Graphics :
All countries are shown
Australia is filtered but don't affect other graphics:
I tried both interactions (filtered and highlight) but it only applies the filter to the current visual.
Is there a way to make the excluded information become a page filter ?
Thanks !
9 Replies
Hey Anonymous ,
yes it is - just move the stuff to the button field. (-> Screenshot down below)
If this post was helpful may I ask you to mark it as solution and give it some kudos?
Have a nice day!
BR,
JosefHi JosefPrakljacic , it is a workaround but I would not be the end-user of the report, therefore I would like to have it in the page filter as standard.
Is it possible?
Ah then you should filter it out in the PowerQuery Editor so it wont appear in the reports for your users.
Here is a ScreenGif
If this post was helpful may I ask you to mark it as solution and give it some kudos?
Have a nice day!
BR,
Josef
Copy and paste the visual. This new visual will retain all of the 'exclude' filters.
Now convert the copied visual to a 'slicer'.
Use the sync slicer settings (found in the view ribbon) to propogate this slicer to all pages in the report as hidden slicers so they will be active in the background.
Some tweaking and config may be needed to get you the results you want: i.e. You may need to add 'select all' option to these slicers so you can select / de-select all options.
Other work arounds may be to use the 'new group' function to create a container that holds all those elements you want excluded and then use this in a slicer.
