Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Hennemann
Frequent Visitor

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 IDTag
1Important; Highlight; Escalation
2Important
3Important; Paused
4Highlight; Paused

 

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

 

Hennemann_0-1700463721982.png

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

Hennemann_1-1700463820774.png

I am sure anyone can help me with this issue.

Kind regards
Tobias

1 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

View solution in original post

13 REPLIES 13
Hennemann
Frequent Visitor

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_0-1700651419358.png

 

Hennemann
Frequent Visitor

Rupak_bi
Helper V
Helper V

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.

please share sample data

Is it OK?

 

Rupak_bi_0-1700647086045.png

 

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.

 

Sorry. There was a mistake . plz check this one

Rupak_bi_0-1700650633524.png

 

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_0-1700651539892.png

 

 

 

Now OK??

Rupak_bi_0-1700652317600.png

 

Yes, that would be a possible 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

Thank you that helped a lot.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.