Negative filter als slicer

[Hennemann]

Hello everyone,

I have a small Issue regarding a slicer.

I would like to have a slicer than can be used as negative filter. For example show me everything which does not include a specific tag.

The origin is a single table with several ID's. Each ID can have several tags (and some other irrelevant columns).

Workitem ID	Tag
1	Important; Highlight; Escalation
2	Important
3	Important; Paused
4	Highlight; Paused

In the next step I have normalized the table, so I can use each tag as seperate filter criteria.

But as you can see I am not able to do a negative select via slicer:

I am sure anyone can help me with this issue.

Kind regards
Tobias

[Hennemann]

I am sorry for the confusion I may caused.
My target is a Slicer, which can be used as negative select
In this case the Highlighted Rows shouldn't be visible due to the slicer (basically show me every row which does not contain "paused")

[Hennemann]

Never Shared sample data before.
Hope this works:
https://www.dropbox.com/scl/fo/9j2j1oaezjhhxz7b464ag/h?rlkey=3b15kde25drqcfx921xa5euuu&dl=0

[Rupak_bi]

Enable "select all" button in slicer formatting. Then publish the report keeping select all enabled. Now if you click on one of the tag, it will be unselected.

[Hennemann]

Thank you for the suggestion, but in this case it does not work as you can see my last printscreen.

In your case I have to unselect each tag of a row, so the row won't show anymore.
For example in my last screenshot I have to unselect "Escalation M42" and "Paused" to not show the row anymore. But in my case I want that unselecting "Escalation M42" or "Paused" is enough to not show them anymore.

[Rupak_bi]

please share sample data

[Rupak_bi]

Is it OK?

[Hennemann]

Positive Filter works as intendet.

Negative Filter does not work. For example select everything except Paused.
It will still show you every row except the one with Index 6 (only row with tag Paused only)
Rows with multiple tags including paused will still be displayed.

[Rupak_bi]

Sorry. There was a mistake . plz check this one

[Hennemann]

I am sorry for the confusion I may caused.
My target is a Slicer, which can be used as negative select
In this case the Highlighted Rows shouldn't be visible due to the slicer (basically show me every row which does not contain "paused")

[Rupak_bi]

Now OK??

[Hennemann]

Yes, that would be a possible solution.

[Rupak_bi · Accepted solution]

Create a Measure

New tags = CALCULATE(Max(Tabelle1[Tags]),NOT(CONTAINSSTRING(Tabelle1[Tags],SELECTEDVALUE(Tags[Tags]))))

• Use this measure in your matrix.
• Remove the relationship between two table

[Hennemann]

Thank you that helped a lot.