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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Dynamic Date Range Selector

Hello,

 

I have a date range selector that uses the 'between' mode, and I was wondering if it's possible at all to have the min and max dates of it update when other filters/slicers are set? So far, it seems like the 'between' date range selector is independent of other filters and doesn't change based on any other filters. Is there a workaround for this?

 

 

Thanks in advance. 

3 REPLIES 3
Anonymous
Not applicable

@v-henryk-mstf 

Thanks for your reply. What I'm trying to do with the date slicer is to have the start and end dates in the 'between' mode change when other filters have been applied. For example, when I have a slicer created using the date column and I'm viewing it in the 'list' mode, when I apply another filter then I can see the value changes based on the filter. However, as soon as I change it to a 'between' mode, it goes back to showing the entire original date range. I would like to have the filter apply to the 'between' mode start and end dates so that the date range updates based on other filters.

Hi @Anonymous ,

 

Other filters do not have an effect on the Between mode slicer, which is independent of other modes. You can post your idea here, If the call for praise is high, Microsoft officials will improve this feature in the next update.


Best Regards,
Henry


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

v-henryk-mstf
Community Support
Community Support

Hi @Anonymous ,

 

As you said, after my tests, between slicer mode does not receive the effects of other filters. It is a separate filtering method.

vhenrykmstf_0-1637562157509.pngvhenrykmstf_1-1637562181965.png

Can you further describe your requirements, such as the application scenario using between slicer mode. I will answer for you as soon as possible.


Best Regards,
Henry


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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.