Exclude rows using slicer

[mhbon]

is it possible to filter all visuals on a report in the following way?

Let's say I made a list of ducks like this:

Name	Surname	Inclusion
Huey	Duck	Include
Dewey	Duck	Exclude
Louie	Duck	Include

Is it possible to create a slicer on a page that when include is selected it shows all ducks but when exclude is selected, it leaves out ducks that have a value for exclude.

So selecting include would result in:

Name	Surname
Huey	Duck
Dewey	Duck
Louie	Duck

And selecting exclude would show only:

Name	Surname
Huey	Duck
Louie	Duck

Or might there be a better way to go about this? I'm really new to Power BI, so all help is really appreciated.

[Pragati11 · Accepted solution]

Hi @mhbon ,

You can use your INCLUSION column as a slicer. Make this slicer Multi-selected and enable SHOW ALL option for this slicer. Check if this works for you.

Refer the following article to see how to you slicers in different ways and with different options:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati