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

[dbhogaraju]

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 .

[dbhogaraju]

Hi @vanessafvg ,

Please find the details below .

Calendar Table : 

Calendar =

var _calendarQA = CALENDAR(MIN('Transaction'[Date]), max('Transaction'[Date]))

return

_calendar

Time table with hour and Minute :

Time =

VAR _series =

GENERATESERIES ( 1, 1440, 1 )

VAR _time =

ADDCOLUMNS ( _series, "TimeandDay", TIME ( 0, [Value], 0 ) )

RETURN

ADDCOLUMNS (

_time,

"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 .

[vanessafvg]

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