How to input Date and Time range in one slicer?

[Anonymous]

Hi, 

Query:

I want to create one slicer where  user can filter the data with date range having time range too (Single field have both Date and Time).

Eg: Suppose date 1st Jan to 10th jan and time starts from 9am 1st Jan and end on 9am 10th jan.

I had proceed with the following approach where I have created a slicer but can select only one value as below.

But if I choose 'Between' option from the dropdown, it is showing me only dates and not time.

So is there any limitation with ragrds to this?

Is there any way to resolve my query?

[Anonymous]

If you got a solution for this post, can you help me how to achieve this, I too have the same requirement.

[bondfranco]

Hi,

Please try using the Visual,Page or report level filter option for this type of requirement.

hope this helps.

[amitchandak]

@ , You can create a date time table using cross join between date and time

Time

https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/

Date

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

Date time = addcolumn( crossjoin('Date', 'Time'), "DateTime", [Date]+[Time])