Forum Discussion

Hennemann's avatar
Hennemann
Frequent Visitor
2 years ago
Solved

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. ...
negative filter
Slicer
  • Rupak_bi's avatar
    Rupak_bi
    2 years ago

    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's avatar
Hennemann
Frequent Visitor
2 years ago

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's avatar
Rupak_bi
Icon for Super User rankSuper User
2 years ago

please share sample data

  • Rupak_bi's avatar
    Rupak_bi
    Icon for Super User rankSuper User
    2 years ago

    Is it OK?

     

     

    • Hennemann's avatar
      Hennemann
      Frequent Visitor
      2 years ago

      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's avatar
        Rupak_bi
        Icon for Super User rankSuper User
        2 years ago

         

        Sorry. There was a mistake . plz check this one