Slicer that includes several filters

[Anonymous]

Hi,

I have  a simple database with two columns:

Items        Category

Item 1        A

Item 2        B     

Item 3        C

I want to filter the rows using a slicer, so when i filter by "A", item 1 shows. When i filter by "B" item 1 and 2 shows, and when I filter by "C" item 1, item 2 and item 3 shows. In other words, I want to include additional filters when I filter by "Categories", depending on the category chosen.

Does anyone know how to do this? Let me know if you need a better explanation 🙂

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

I create a measure and a index column to implement you can have a try.

1. Create an index column from 1 in Power Query. Then apply and close.

1. Create a new table contained the values you want to filter. And there is no relationship between the two tables.

1. Create a measure.

Filter =
var selc = SELECTEDVALUE(Table2[Category])
var selind =CALCULATE(MAX(Table1[Index]),FILTER(ALL(Table1),Table1[Category] = selc))
return
IF(MAX(Table1[Index])<=selind, MAX(Table1[Items]),BLANK())

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.