Date Range and Numeric Range Slicer are not working Properly

[Anonymous]

Dear All,

I have a calendar Table which has 2 fields - Date and Numeric Period(which is a fiscal Period)

So lets suppose if the date is 01-JAN-2010 , then the Corresponding Period is 201001(20 -year , 10 -period , 01 -week)

I am using both of them as slicers in my PBI report , one is date Slicer and other is Numeric slicer .
Both of them are range for ex - 
Date - 01-Jan-2020 to 31-Mar-2020        Period  - 201001  to 201104

The issue is both these range slicers are not syncing properly ,when i am changing one slicer through different ranges , the other one is changing properly , everything is fine , the moment i start changing the range in other slicer ...the slicers stop syncing  ie then the values stop changing in other slicers  , need help on this !

[amitchandak]

@Anonymous , If you are to use Year Month week as a numeric slicer, it might not work as expected. You will get all the values between range and that will not be limited to the values of YYMMWW.  like 201354

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

@amitchandak Thanks for your time , below is the sample data ,Period 201001 is a fiscal period and in 201001 ,10 is not a month but is a period :

Date	Year	Quarter	Month	Week	Period
7/1/2020	2020	3	7	27	201001
7/2/2020	2020	3	7	27	201001
7/3/2020	2020	3	7	27	201001
7/4/2020	2020	3	7	27	201001
7/5/2020	2020	3	7	27	201002
7/6/2020	2020	3	7	28	201002
7/7/2020	2020	3	7	28	201002
7/8/2020	2020	3	7	28	201002
7/9/2020	2020	3	7	28	201002
7/10/2020	2020	3	7	28	201002
7/11/2020	2020	3	7	28	201002
7/12/2020	2020	3	7	28	201003
7/13/2020	2020	3	7	29	201003
7/14/2020	2020	3	7	29	201003
7/15/2020	2020	3	7	29	201003
7/16/2020	2020	3	7	29	201003
7/17/2020	2020	3	7	29	201003
7/18/2020	2020	3	7	29	201003
7/19/2020	2020	3	7	29	201004
7/20/2020	2020	3	7	30	201004
7/21/2020	2020	3	7	30	201004
7/22/2020	2020	3	7	30	201004
7/23/2020	2020	3	7	30	201004
7/24/2020	2020	3	7	30	201004
7/25/2020	2020	3	7	30	201004
7/26/2020	2020	3	7	30	201005
7/27/2020	2020	3	7	31	201005
7/28/2020	2020	3	7	31	201005
7/29/2020	2020	3	7	31	201005
7/30/2020	2020	3	7	31	201005
7/31/2020	2020	3	7	31	201005
8/1/2020	2020	3	8	31	201005
8/2/2020	2020	3	8	31	201101
8/3/2020	2020	3	8	32	201101
8/4/2020	2020	3	8	32	201101
8/5/2020	2020	3	8	32	201101
8/6/2020	2020	3	8	32	201101
8/7/2020	2020	3	8	32	201101
8/8/2020	2020	3	8	32	201101
8/9/2020	2020	3	8	32	201102
8/10/2020	2020	3	8	33	201102
8/11/2020	2020	3	8	33	201102
8/12/2020	2020	3	8	33	201102
8/13/2020	2020	3	8	33	201102
8/14/2020	2020	3	8	33	201102
8/15/2020	2020	3	8	33	201102
8/16/2020	2020	3	8	33	201103
8/17/2020	2020	3	8	34	201103
8/18/2020	2020	3	8	34	201103
8/19/2020	2020	3	8	34	201103
8/20/2020	2020	3	8	34	201103
8/21/2020	2020	3	8	34	201103
8/22/2020	2020	3	8	34	201103
8/23/2020	2020	3	8	34	201104
8/24/2020	2020	3	8	35	201104
8/25/2020	2020	3	8	35	201104
8/26/2020	2020	3	8	35	201104
8/27/2020	2020	3	8	35	201104
8/28/2020	2020	3	8	35	201104
8/29/2020	2020	3	8	35	201104
8/30/2020	2020	3	8	35	201201
8/31/2020	2020	3	8	36	201201

[Sumanth_23]

@Anonymous - Just for my understanding - what format are you using to select values for your slicers? Seems to work as expected if I use a list for the slicers - see below 

 Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

[Anonymous]

@Sumanth_23 As i said earlier , the issue is not coming with list , it is coming while using range in both the slicers.

[Sumanth_23]

@Anonymous - Can you share the sample data or the PBIX file? 

I mocked up the data (the period logic may not be entirely correct) but the slicers are working as expected - see screen grabs below 

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!