Using Slicer to turn on and off a filter

[Anonymous]

Hi,

I have a dataset in which I would like to filter some rows with a specific identifier(MLs) which exist in a different column. Is there a way to use a slicer to filter out the rows with such identifier? (e.g.  like an On and Off button) so when you use a chiclet slicer to choose "With MLs" it includes the rows with this identifier and when you don't choose it, it shows you all your rows?

Thanks

@MFelix 

[parry2k]

@Anonymous so does your tables look like this

ML    ML FIlter

1         2

2

3

4         5

5

6

So when fiter is turned on , you want to exclude rows where ML is 2 and 5 otherwise show all rows.

[Anonymous]

@parry2k  it is similar to what I asked except the fisrt column is not sorted in order, so it would be like:

1  

45      ML

2  

10      ML

5

3

19       ML

901

12

67

How to do it?

[parry2k]

@Anonymous doesn't matter if first column is in order or not. I'm not sure give the data example what you want the output to be? Can you please clarify?

[Anonymous]

@parry2k  the final visual is a gauge and I'd like to have a chiclet with two condition: one condition is with MLs and another without them. The chiclet should be always in one of two available conditions, with MLS included and without MLs.

I think it is now completely clear if you really can help...

Thanks

[Anonymous]

@Anonymous  please let me have your reply?