Forum Discussion
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...
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
bumping it to see if anyone can help, please
v-easonf-msft
Community Support
Community SupportHi, 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