Forum Discussion
Selecting active hour(s)
In our production environment we need to make a report that is based on shifts.
In the report I need to select the active day, active shift and active hours te display.
I used the selective date filter for now to select the day.
I made a new column to return the value "True" to if an shift is active. I filter on page level to only show the active shift.
However this does work fine if I just make a table that shows me the result of the active day in a filter.
However if I look at complete day, devided in hours per shift, it always returns as True.
I just need the 8 hours displayed of the active shift and not 24 hours.
For now I just select the active shift in the shift filter and it work fine.
Not all the people i want to show this report can do this (acces rights and stuff.
Does anyone know how to get this result by automaticly filter for active day, shift and 8hours within the shift:
1 Reply
- v-cherch-msftMicrosoft Employee
Hi Anonymous
I cannot full understand it.It seems you may add a measure like below to visual level filter.If it is not your case, please share some data sample and expected output. You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.
Measure = IF ( MAX ( Table[NewDate] ) = TODAY (), 1 )
How to Get Your Question Answered Quickly
Regards,
Cherie