Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

0

How to get Time Range in Power BI

Hello all!

Hope everyone is doing great!
I am getting some issues while having time range. 
Suppose I want to see all mobiles purchased from 01 Jan 2019 at 11:00 am to 05 Jan 2019 till 05:00 pm.
Now i could have date filter, but how could i manage for time range given above?

I do not want to see sale made on 01 Jan 2019 before 11:00 am and on 05 Jan 2019 after 5:00

Please help!

Cheers

 

Status: Delivered
Comments
v-yuezhe-msft
Employee

@Anonymous ,

Only list and dropdown options are available when you place datetime field in a slicer, it is not possible to use between option, there is an idea about this issue, please vote it up.

To workaround this issue, please create two seperate datetime tables listing all possible start datetime adn endtime, then create a measure to check the datetime range, for more details, please take a look at this similar thread.

Regards,
Lydia

v-yuezhe-msft
Employee
Status changed to: Delivered