Forum Discussion
Negative filter als slicer
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
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
13 Replies
- Rupak_bi
Super User
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.
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
Never Shared sample data before.
Hope this works:
https://www.dropbox.com/scl/fo/9j2j1oaezjhhxz7b464ag/h?rlkey=3b15kde25drqcfx921xa5euuu&dl=0I 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")
