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 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 |
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
2 Replies
- v-easonf-msft
Community Support
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