Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Filter data on table using Slicers for a date, hour and min for both start and end

I have a Calendar table with date in my report. My requirement is to create slicers for a date, hour and min for both start and end.

Currently, I am able to filter the table data by start and end date.

But I am not able to filter "table" data by start and end hour or min(eg:1/5/2021 5:05 AM to 2/20/2021 2:46 PM).

Nothing is working. Can anyone help me with this issue by providing a sample pbix .




Regular Visitor

Hi @vanessafvg ,

Please find the details below .


Calendar Table : 

Calendar =
var _calendarQA = CALENDAR(MIN('Transaction'[Date]), max('Transaction'[Date]))
Time table with hour and Minute :
Time =
VAR _series =
GENERATESERIES ( 1, 1440, 1 )
VAR _time =
ADDCOLUMNS ( _series, "TimeandDay", TIME ( 0, [Value], 0 ) )
"TimeKey", FORMAT([TimeandDay], "hhmm"),
"Actual Time", FORMAT ( [TimeandDay], "HH:MM AM/PM" ),
"Hour", HOUR ( [TimeandDay] ),
"Hour Extended", FORMAT([TimeandDay], "H AM/PM"),
"Minute", MINUTE ( [TimeandDay] ),
"AMPM", FORMAT ( [TimeandDay], "AMPM" )
Below is sample transaction table data just for reference on which I am trying to use the date time slicers .


Super User I
Super User I

what is your model structure?  and can you show what your calendar table looks like?   and how its related to your transactions

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors