Forum Discussion
undefined
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.
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
6 Replies
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
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.
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
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
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
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.
