Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a table of many datetime datapointname value triplets from process probe sensors.
Does anyone how how to set up a slicer or set of slicers so I can filter my report (for example), from 2022-Jun-15 at 4:30 PM to 2022-Jun-18 at 10:00 AM?
I am just learning about DAX. I have spent a few hours at this with no sucess.
Thanks
Solved! Go to Solution.
While I don't mind anyone's comments on how to accomplish building a date/time slicer which might go from half way through another day I would like to report that I found an elegant alternative.
My data has a date and time stamp and a data_point_id and a value. I wanted to slice/filter so the user can filter by time from one point on day A to another time on day B. I have a bad habit of doubling down trying to solve a problem with little latteral thinking
Then I realized that every record also has a unique record id (big integer) which goes up with time. So I set the splitter to that and made some measures and card visuals to get the min and max datetime
It only needs one splitter (instead of two or three) and looks good to the user
While I don't mind anyone's comments on how to accomplish building a date/time slicer which might go from half way through another day I would like to report that I found an elegant alternative.
My data has a date and time stamp and a data_point_id and a value. I wanted to slice/filter so the user can filter by time from one point on day A to another time on day B. I have a bad habit of doubling down trying to solve a problem with little latteral thinking
Then I realized that every record also has a unique record id (big integer) which goes up with time. So I set the splitter to that and made some measures and card visuals to get the min and max datetime
It only needs one splitter (instead of two or three) and looks good to the user
Hi, @PowerBI-ELM
Glad you found a workaround and shared it here.
It will help other community members easily find solutions when they encounter similar problems.
Best Regards,
Community Support Team _ Eason