Skip to main content
cancel
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
ADSL
Post Prodigy
Post Prodigy

How to create the start/end date of slicer

Hi BI Community Team,

 

I have a date table, month and date. To getting more easy for user to choose the start and end date of the month.

 

We want to create and apply the slicer that have start and end date as the screenshot below. 

 

Any suggestion/advise? 

 

Sample pbix file: https://drive.google.com/drive/folders/1v66vRAhwzL2XIddDmhFEDjJXKXHNjPO7?usp=sharing 

 

2023-05-07_14-11-36.png

Thanks and Regards,

1 ACCEPTED SOLUTION

Make Sure that both filter & slider are connected to Date filed from Calendar table

MohTawfik_0-1683460903601.png

also make sure to edit interactions for both filter and slider to filter eachother 

MohTawfik_3-1683466605630.png

 

MohTawfik_4-1683466744631.pngMohTawfik_5-1683466766995.png

 

View solution in original post

4 REPLIES 4
MohTawfik
Resolver I
Resolver I

@ADSL 

Your are looking for a date slider that will return sales during a aspecific period!

MohTawfik_0-1683449549819.png

 

Slicer Calendar.pbix 

check If this is what you are looking for.

Hi @MohTawfik,

 

Thank you for your helpful feedback.

 

As per your screenshot and file pbix sharing, it's correctly working. But when I am trying to create the new with more data, then it's not working. It's still showing the 01/01/2022 and 31/12/2023.

 

Date seem not to be following the Year + Month selected. I am not sure file, it's manual choose or dynamic follow the month.

 

Please kindly check and advise if I am doing wrong.

 

2023-05-07_18-26-24.png

Make Sure that both filter & slider are connected to Date filed from Calendar table

MohTawfik_0-1683460903601.png

also make sure to edit interactions for both filter and slider to filter eachother 

MohTawfik_3-1683466605630.png

 

MohTawfik_4-1683466744631.pngMohTawfik_5-1683466766995.png

 

Hi @MohTawfik ,

 

Thank you for your helpful feedback. It's working as expectation now.

 

2023-05-13_10-52-22.png

 

Best Regards,

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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