Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Date Range and Numeric Range Slicer are not working Properly

‎09-20-2020 11:30 AM

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 !

Labels:
Message 1 of 6
409 Views
0
5 REPLIES 5
amitchandak
Super User
Super User

‎09-20-2020 06:15 PM

@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.



Message 3 of 6
349 Views
0
Anonymous
Not applicable
In response to amitchandak

‎09-21-2020 02:26 AM

@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 :

DateYearQuarterMonthWeekPeriod
7/1/202020203727201001
7/2/202020203727201001
7/3/202020203727201001
7/4/202020203727201001
7/5/202020203727201002
7/6/202020203728201002
7/7/202020203728201002
7/8/202020203728201002
7/9/202020203728201002
7/10/202020203728201002
7/11/202020203728201002
7/12/202020203728201003
7/13/202020203729201003
7/14/202020203729201003
7/15/202020203729201003
7/16/202020203729201003
7/17/202020203729201003
7/18/202020203729201003
7/19/202020203729201004
7/20/202020203730201004
7/21/202020203730201004
7/22/202020203730201004
7/23/202020203730201004
7/24/202020203730201004
7/25/202020203730201004
7/26/202020203730201005
7/27/202020203731201005
7/28/202020203731201005
7/29/202020203731201005
7/30/202020203731201005
7/31/202020203731201005
8/1/202020203831201005
8/2/202020203831201101
8/3/202020203832201101
8/4/202020203832201101
8/5/202020203832201101
8/6/202020203832201101
8/7/202020203832201101
8/8/202020203832201101
8/9/202020203832201102
8/10/202020203833201102
8/11/202020203833201102
8/12/202020203833201102
8/13/202020203833201102
8/14/202020203833201102
8/15/202020203833201102
8/16/202020203833201103
8/17/202020203834201103
8/18/202020203834201103
8/19/202020203834201103
8/20/202020203834201103
8/21/202020203834201103
8/22/202020203834201103
8/23/202020203834201104
8/24/202020203835201104
8/25/202020203835201104
8/26/202020203835201104
8/27/202020203835201104
8/28/202020203835201104
8/29/202020203835201104
8/30/202020203835201201
8/31/202020203836201201
Message 4 of 6
331 Views
0
Sumanth_23
Memorable Member
Memorable Member
In response to Anonymous

‎09-21-2020 02:50 AM

@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 

Sumanth_23_2-1600681702418.png

 

Sumanth_23_0-1600681676669.png

 

Sumanth_23_1-1600681689965.png

 

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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!

Proud to be a Super User!



Message 5 of 6
328 Views
0
Anonymous
Not applicable
In response to Sumanth_23

‎09-21-2020 03:02 AM

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

Message 6 of 6
327 Views
0
Sumanth_23
Memorable Member
Memorable Member

‎09-20-2020 12:10 PM

@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 

 

Sumanth_23_0-1600628833142.png

 

Sumanth_23_1-1600628846456.png

 

Sumanth_23_2-1600628855807.png

 

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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!

Proud to be a Super User!



Message 2 of 6
376 Views
0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

View All