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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
akarna772
Frequent Visitor

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
akarna772
Frequent Visitor

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.