Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Custom filter with criteria

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 s...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

bumping it to see if anyone can help, please

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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