Forum Discussion
Time slicing visuals using a TimeTable
Hello
Needing some guidance please.
My dataset consists of sample labels and occurred_time (HH:MM:SS) format
I have created a TimeTable that consists of all timestamps in a day and is further broken down into Hour and Minute columns (i.e the timetable has columns TimeStamp, Hour, Minute)
I then joined the TimeStamp field to the occurred_time field in my dataset
I have several visuals that I wish to slice by time and set up two slicers one using Hour and the other using Minute (see first image), however this is not reflecting the correct data in the visuals. It returns data for hour 14 at the selected minutes and data for hour 15 at the selected minutes as well as data between hours 14 and 15...
I essentially want to have a "start" occured_time and an "end" occurred time at an hour minute level that returns all rows that are inclusive and between these two selected times.
i.e (indiacted by S - start and E - end in the image) it should return occurred times that occure between 14:28 and 15:38... I dont know if this way is possible or if there is another way to go about this.
Please advise. Thank You
Photo 1.
4 Replies
Hi HB_1110 ,
Here is my sample data:
There is no relationship between these two tables:Use this DAX to create a measure:
Filter = VAR _minhour = MIN('TimeTable'[Hour]) VAR _maxhour = MAX('TimeTable'[Hour]) VAR _minminute = MIN('TimeTable'[Minute]) VAR _maxminute = MAX('TimeTable'[Minute]) VAR _mintime = TIME(_minhour,_minminute,0) VAR _maxtime = TIME(_maxhour,_maxminute,0) RETURN IF( MAX('Table'[occurred_time]) <= _maxtime && MAX('Table'[occurred_time]) >= _mintime, 1, 0 )Make the settings as shown in the following figure:
And the final output is as below:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi HB_1110 ,
We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
B Manikanteswara ReddyHi @HB_1110 ,
We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
B Manikanteswara ReddyHi @HB_1110 ,
We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
B Manikanteswara Reddy
