cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills 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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors