Forum Discussion
undefined
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
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