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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Anonymous
Not applicable

Include hour and minute in date between filter

I require the visualization filtered by date and time. For example: filter the date from xx/xx/xxxx hh:mm to xx/xx/xxxx hh:mm. I want this to get integrated in slicer. There is the option in advance filtering but i require it in slicer. Please help ... 

2 REPLIES 2
Anonymous
Not applicable

Is it possible to have this requirement 8 september 2022 8:00 am to 10 sept 2022 8:00pm from two dimension table. If you have code sample.. it will be a great help.

JorgePinho
Solution Sage
Solution Sage

Although it would be convenient to have the date and time on the same slicer, doing so would add a lot of extra bulk to your data model. The number of days on your calendar would be multiplied by the 1440 minutes in one day. Over 500,000 rows would be created by one calendar.

 

Therefore, separating the date and time into two dimension tables and using one slicer for date and another for time is the best option.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 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.