Slicer - Date and Time (From time A to time B)

[Anonymous]

Hi,

I'm building a 24 hour report for management, with the sales for the "past 24 hours".

Unfortunatly invoices are billed manually, meaning that the actual "24 hour" period varies greatly, as it will change depending on if the report is influenced by end of month biling, holidays, weekends etc...

Essentially I have sales data in a seperate table with the invoice date and specific invoice time in hh/mm/ss.

For filtering I have a seperate Date and Time tables as I understand this is recommended, since a combined table would be very big - slow model

However, what I essentially want is a normal date slicer, just with the added aspect of being able to also set the specific time, i.e. a slicer that lets me input something similar to: 01-10-2017 08:30:00 to 02-10-2017 08:29:59

Is this possible, and how would I come around to achive that functionality?

[Anonymous]

From my initial investigation into the problem, it seems that PBI slicers are not currently able to handle time as input.

Would it then be best to somehow include my filtering in the measures instead?

[v-huizhn-msft]

Hi @Anonymous,

You're right. Power BI slicer are not handle time as input. Please review this feature request and vote it. 

For another, you can create two measures to get TimeA and TimeB using the formulas.

TimeA = DATE(2017,1,10)+TIME(08,30,0)
TimeB = DATE(2017,2,10)+TIME(08,29,59)

Then you can filter your table using similar formula below.

New=Filter(Table,Table[Date]>=TimeA&&Table[Date]<=TimeB)

Best Regards,
Angelia

[Anonymous · Accepted solution]

I made a work-around including using two seperate tables that function as my input variables for cut-off time points.

Seperate post her:

https://community.powerbi.com/t5/forums/replypage/board-id/power-bi-designer/message-id/120268