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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Vibration85
Helper II
Helper II

How to show a filter between two consecutive date (show two consecutive dates only)

Hello everyone,

 

Are there any solutions to show a Between Slicer with only two consecutive dates every time we select one date? 

I mean If I choose 10/01/2021 then the next date automatically changes to 11/01/2021, like the image below 

 

I really appreciate any could help me.

Vibration85_0-1611159618153.png

 

4 REPLIES 4
wdx223_Daniel
Super User
Super User

@Vibration85 think you can use two date table with a filter measure to do this trich

wdx223_Daniel_0-1611197055168.png

 

Thank you, but Are there any other solutions with only one date filter? I want to show only one day period (2 dates) in each selection 

amitchandak
Super User
Super User

@Vibration85 , No, I doubt that is possible in the slicer. You can not initialize the slicer using some function.

 

Please log an idea - https://ideas.powerbi.com/ideas/

Could you let me know which type of Function or DAX code I can use? as I have a long list of dates (years and Months)

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors