undefined

[venkat_chaganti]

Hi guys, I am looking for a time slicer where i can select time in between format similar to date slicer. Please respond back if you guys have any idea how to do it.

[Anonymous · Accepted solution]

Thanks for the reply from @AmiraBedh and @amitchandak , please allow me to provide another insight: 

Hi  @venkat_chaganti ,

I created some data:

Here are the steps you can follow：

1. Create calculated table.

Date = GENERATESERIES (TIME (0, 0, 0), TIME (23, 59, 59), TIME (0, 15, 0))

2. Create measure.

Flag =
var _mintime=MINX(ALLSELECTED('Date'),[Value])
var _maxtime=MAXX(ALLSELECTED('Date'),[Value])
var _time=TIME(
    HOUR(MAX('Table'[Date])),MINUTE(MAX('Table'[Date])),SECOND(MAX('Table'[Date])))
return
IF(
    _time>=_mintime&&_time<=_maxtime,1,0)

3. Place [Flag]in Filters, set is=1, apply filter.

4. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[venkat_chaganti]

Hi, thanks for the solution we have done it simalrly but we didn't create any dax fuction when we have done. I have manually entred the data in transform data by creating a new table. we will try with solution you have provided.
Thank you for taking your time to answer my questions.

[AmiraBedh]

Create a new table in Power BI that contains the time intervals you want to slice :

TimeTable =
ADDCOLUMNS (
GENERATE (
CALENDAR (DATE(2021, 1, 1), DATE(2021, 1, 1)),
GENERATESERIES (TIME (0, 0, 0), TIME (23, 59, 59), TIME (0, 15, 0))
),
"Time", [Date] + [Value]
)

Create a relationship between your main data table and the new time table based on the time columns and add the time column from your new time table to the slicer visual in your report. Then change the slicer settings to "Between" to allow users to select a range of time.

More links :

https://learn.microsoft.com/en-us/power-bi/create-reports/slicer-filter-relative-time

https://community.fabric.microsoft.com/t5/Desktop/Slider-Slicer-that-Includes-Time-Not-just-Date/td-...

[venkat_chaganti]

we have already tried by inserting the timelines that we require .
I want to create is a time slicer wit 24 hr format where i can select from one particular toother. for example i want to display the data from 11:00 am to 11:30 am like this

[amitchandak]

@venkat_chaganti , You have timeline slicer

https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104380786?tab=overview

Or the workaround using 2 slicers

Select data between months - https://youtu.be/nEt7dT3Tfv4

[venkat_chaganti]

we have already used timeline slicer what i excatly want to create is a time slicer wit 24 hr format where i can select from one particular toother. for example i want to display the data from 11:00 am to 11:30 am like this.