Custom filter with criteria

[Anonymous]

Hello 

I need some help with a slicer filter. Below is the example. What I need is a Slicer for CIR column, where it don't show all the values, instead I need values like <50,<250 & <900 in the slicer for CIR and once selected from that column it will show all the values that qualify the criteria

so if I select CIR <50 it show all columns in table that has CIR < 50 and also have additional filters <250, <900 in the filtering options.

Code	Category	CIR
A1	New	10
B2	On-Air	50
C4	New	5
D4	Active	800
E3	Active	2000
F3	Active	8
G2	New	10
H1	On-Air	250
K1	On-Air	600

[Anonymous]

bumping it to see if anyone can help, please

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

Please try following steps:

1.enter a table as below

2.add new measures:

<50 = IF(MAX('Table'[CIR])<50,1,0)

<250 = IF(MAX('Table'[CIR])<250,1,0)

<900 = IF(MAX('Table'[CIR])<900,1,0)

filter = 
VAR a =
    SWITCH (
        SELECTEDVALUE ( Parameter[Parameter] ),
        "<50", [<50],
        "<250", [<250],
        "<900", [<900]
    )
RETURN
    IF ( ISFILTERED ( Parameter[Parameter] ), a, 1 )

3.drag the new measure 'filter' to visual filter pane as below:

Best Regards,
Community Support Team _ Eason