Forum Discussion
Exclude rows using slicer
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.
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
1 Reply
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