Filter need to apply all pages based on slicer selection

[sanjaymithran]

Hi All

Need to create slicer Values 5 and 10 ,If i select 5 then Lapse(whole number) 0 to 5,select 10 then all lapse values, lapse is not in table visual

Lapse

0

1

2

3

4

5

6

7

8

9

10

Dim	LAPSE	Measure		10 Yr
Desc	0	-150361		Dim	Measure	Measure2
Desc	1	277236.8		Desc	910450	910450
Desc	2	168730		Desc1	63969.1	63969.1
Desc	3	130182.2		Desc2	-287787	-287787
Desc	4	106985
Desc	5	90943.1		5 Yr
Desc	6	77306.4		Dim	Measure	Measure2
Desc	7	65714.9		Desc	623715.8	910450
Desc	8	55861.8		Desc1	42750.8	63969.1
Desc	9	47485.8		Desc2	-435061	-287787
Desc	10	40365.4
Desc1	0	-11050
Desc1	1	17035.4
Desc1	2	12485.7
Desc1	3	9633.3
Desc1	4	7916.7
Desc1	5	6729.6
Desc1	6	5720.7
Desc1	7	4863
Desc1	8	4133.9
Desc1	9	3513.9
Desc1	10	2986.8
Desc2	0	-818316
Desc2	1	128065.6
Desc2	2	86663.2
Desc2	3	66864.8
Desc2	4	54950.5
Desc2	5	46710.7
Desc2	6	39706.7
Desc2	7	33752.6
Desc2	8	28691.9
Desc2	9	24390
Desc2	10	20732.9

[sanjaymithran]

Hi qqqqqwwwweeerrr

I have tried this already same as you mentioned,when filter 5 its working fine when filter 10 its shows 6 to 10 only but need to show 0 to 10 and one more Measure2 to show values irrespective of filter 5 or 10

[qqqqqwwwweeerrr]

Hi @sanjaymithran 

You can create new columns using this if else statment:

Filter = IF(Sheet5[LAPSE]<= 5,5,10)

And use that in filter

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem

Regards