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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

How to make a Calendar type Date Slicer?

Hi, 
I have been struggling to make a slicer which has date in a calendar format. I have two tables named StartDateTable and EndDateTable which have a Date Field. These Date Fields are bound to parameters StartTimeParameter and EndTimeParameter respectively and upon changing the slicers in the report it makes a live direct query with the new values of parameters. 

rohandas_0-1719392360402.png

rohandas_1-1719392422972.png

 

rohandas_2-1719392500839.png


The queries are all working fine, I just want a better visual representation, as it gets tedious to scroll the date list. Thanks for any help in this regard. 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Thanks for the reply from @amitchandak , please allow me to provide another insight: 

Hi  @Anonymous ,

You might consider using a custom visual -- Date Picker.

vyangliumsft_0-1719465330029.png

Dynamic date slicer to filter multiple dates or date ranges, presets, calendar views, themes and customizations

vyangliumsft_1-1719465330033.png

This is an introduction to Date Picker viusal, I hope it helps you:

Date Picker (microsoft.com)

 

Best Regards,

Liu Yang

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

View solution in original post

4 REPLIES 4
Yunus_Miah
Frequent Visitor

I personally prefer to use between slicer for Calendar slicer. You can choose from the calender and can use the range from the panel.

Anonymous
Not applicable

Thanks for the reply from @amitchandak , please allow me to provide another insight: 

Hi  @Anonymous ,

You might consider using a custom visual -- Date Picker.

vyangliumsft_0-1719465330029.png

Dynamic date slicer to filter multiple dates or date ranges, presets, calendar views, themes and customizations

vyangliumsft_1-1719465330033.png

This is an introduction to Date Picker viusal, I hope it helps you:

Date Picker (microsoft.com)

 

Best Regards,

Liu Yang

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

Anonymous
Not applicable

I have used Date Picker but it didn't work. Please, understand that my queries are direct and it makes a direct query when I change the date. So, there is no notion of filtering, as I don't have the data available with me right away. 

amitchandak
Super User
Super User

@Anonymous , Not very clear. You can use between slicer or timeline slicer, add from app source. 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors