topic Re: Negative filter als slicer in DAX Commands and Tips

Negative filter als slicer

Hennemann — Mon, 20 Nov 2023 07:09:12 GMT

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

Re: Negative filter als slicer

Rupak_bi — Mon, 20 Nov 2023 07:36:51 GMT

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.

Re: Negative filter als slicer

Hennemann — Mon, 20 Nov 2023 08:18:27 GMT

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.

Re: Negative filter als slicer

Rupak_bi — Tue, 21 Nov 2023 12:46:29 GMT

please share sample data

Re: Negative filter als slicer

Hennemann — Wed, 22 Nov 2023 09:31:42 GMT

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

Re: Negative filter als slicer

Rupak_bi — Wed, 22 Nov 2023 09:58:22 GMT

Is it OK?

Re: Negative filter als slicer

Hennemann — Wed, 22 Nov 2023 10:06:47 GMT

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.

Re: Negative filter als slicer

Rupak_bi — Wed, 22 Nov 2023 10:58:43 GMT

Sorry. There was a mistake . plz check this one

Re: Negative filter als slicer

Hennemann — Wed, 22 Nov 2023 11:11:44 GMT

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")

Re: Negative filter als slicer

Hennemann — Wed, 22 Nov 2023 11:12:28 GMT

Re: Negative filter als slicer

Rupak_bi — Wed, 22 Nov 2023 11:25:28 GMT

Now OK??

Re: Negative filter als slicer

Hennemann — Wed, 22 Nov 2023 11:33:27 GMT

Yes, that would be a possible solution.

Re: Negative filter als slicer

Rupak_bi — Wed, 22 Nov 2023 11:37:26 GMT

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

Re: Negative filter als slicer

Hennemann — Wed, 22 Nov 2023 12:01:48 GMT

Thank you that helped a lot.