How I can customize my filters?

[MQaiserJaved]

Hi,

I am using following data for my table visual.

SrNo	Level 1	Level 2	Level 3	Level 4	Level 5	Level 6	Sales
1	Zone1	Region1					5
2	Zone2	Region1					10
3	Zone3	Region1					10
4	Zone4	Region2					5
5	Zone5	Region2					5
6	Zone6	Region2					15
7	Zone7	Region3					10
8	Zone8	Region3					10
9	Zone9	Region3					10
10	Zone10	Region3					10
11	Zone11	Region3					10
12	Zone12	Region3					10
13		Region1	Building1				25
14		Region1	Building1				25
15		Region1	Building1				25
16		Region2	Building1				25
17		Region2	Building1				25
18		Region2	Building1				25
19		Region3	Building2				60
20		Region3	Building2				60
21		Region3	Building2				60
22		Region3	Building2				60
23		Region3	Building2				60
24		Region3	Building2				60
25			Building1	Floor1			50
26			Building1	Floor1			50
27			Building1	Floor1			50
28			Building1	Floor1			50
29			Building1	Floor1			50
30			Building1	Floor1			50
31			Building2	Floor2			60
32			Building2	Floor2			60
33			Building2	Floor2			60
34			Building2	Floor2			60
35			Building2	Floor2			60
36			Building2	Floor2			60
37				Floor1	Hall1		50
38				Floor1	Hall1		50
39				Floor1	Hall1		50
40				Floor1	Hall1		50
41				Floor1	Hall1		50
42				Floor1	Hall1		50
43				Floor2	Hall2		60
44				Floor2	Hall2		60
45				Floor2	Hall2		60
46				Floor2	Hall2		60
47				Floor2	Hall2		60
48				Floor2	Hall2		60
49					Hall1	Counter1	50
50					Hall1	Counter1	50
51					Hall1	Counter1	50
52					Hall1	Counter1	50
53					Hall1	Counter2	50
54					Hall1	Counter2	50
55					Hall2	Counter2	60
56					Hall2	Counter2	60
57					Hall2	Counter2	60
58					Hall2	Counter3	60
59					Hall2	Counter3	60
60					Hall2	Counter3	60
61

And using the columns Level 1 to Level 6 in slicer. As shown below.

When I apply filter from slicer Level 3 and select Building1. The records filter as shown below.

But I want the filter behavior for example when I filter Level 3, select Building1, then it should show record for Level3 = Building1 and also Level2 IN (Region1, Region2) and also Level1 IN (Zone1 to Zone6) means consider backward columns and similarly consider forward columns e.g. Level4 (Floor1), Level5 (Floor1->, Hall1) and Level6 (Hall1-> Counter1 and Counter2.

Your help is really appreciated.

Thanks & Regards,

Qaiser

[v-jiewu-msft]

Hi @MQaiserJaved ,

Based on my testing, it is may impossible to achieve when level1 to level6 are inside the same table. If selecting the Building 1 in Level 3, the Level 1 can not show zone1 to zone6. You can try to modify the data in the table.

Best Regards,

Wisdom Wu

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