cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dbhogaraju
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 .

 

dbhogaraju_0-1620476720379.png

 

2 REPLIES 2
dbhogaraju
Regular Visitor

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 .
 
 
dbhogaraju_0-1620479488442.png

 

vanessafvg
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

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

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.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors