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.

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