Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Date slicer dosn't update correctly intercating with a time period slicer

Hi 

 I am using two slicers both coming from the same date table, one is for filtering the periods and the second is to make it more

customizable. Both are supposed to filter each other so if I select the last week, the date slicer will present the dates in the last week. The idea is that users will be able to customize the date inside each period for themselves. 

Untitled.png

The problem is if I change the date slicer after selecting a period it remains on that date on the visual although I change the period filter afterward. In the background, the filter works correctly but it doesn't show the correct date in the date slicer unless I reset the visual.

Untitled.png

How can I solve this? 

 

Thanks in advance

 

Status: Investigating

Hi @Anonymous ,

It works in my side. Please try to reopen the report and create a new one.

slicer.gif

 

 

 

 

 

 

 

 

 

 

Best regards,

Community Support Team_yanjiang

Comments
v-yanjiang-msft
Community Support
Status changed to: Investigating

Hi @Anonymous ,

It works in my side. Please try to reopen the report and create a new one.

slicer.gif

 

 

 

 

 

 

 

 

 

 

Best regards,

Community Support Team_yanjiang

Anonymous
Not applicable

Hi

Please change the date slicer ( the second one) and then change the filter on the first one. You would see that the date slicer remains on what you set previously and doesn't get updated. What you show me here is not matched the problem that I have and I already made it after reopening the report a few times.

Thanks 

v-yanjiang-msft
Community Support

Hi @Anonymous ,

Do you mean for example

1.First set the relative slicer to last 1 month, the between slicer works fine.

2.Manually change the between slicer to 2023/3/1-2023/3/10.

3.Then change the relative slicer to last 1 week, the between slicer cann't get the corresponding result.

slicer.gif

Best regards,

Community Support Team_yanjiang

Anonymous
Not applicable

Hi 

Yes but instead of a relative slicer at top, I'm using a period slicer which is set in my date table. 

Regards

Parissa