There's probably a more DAX / Programmtic way of doing this, but I tend to be very 'logic driven' in my work.. There's always more than 1 way to solve a problem....
1. User PowerBI to Duplciate your data into 2 new columns formatting them Date (To get Date Only) and Time (To get Time Only).
2. Create the following Custom Columns outside of Query Editor:
Minutes = DATEDIFF(DATE(1899,12,30),Table1[Time ONLY],MINUTE) // A Test run at producing Minutes only from a TIME formatted column.
5Min_Data = INT(DATEDIFF(DATE(1899,12,30),Table1[Time ONLY],MINUTE) / 5) // INTEGER your minutes divided by 5 to give you whole numbers to group you data by...
5Min_Time = TIME( INT([5Min_Data]*5/60), (( ([5Min_Data]*5/60)-INT([5Min_Data]*5/60))*60) ,0) // Nobody wants to see '11/21/2016 60' or 11/21/2016 180' - Use this logic to rebuild a TIME format in 5 minute intervals.
3. Create your visual with 'Date Only' and '5Min_Time' stacked on the Asix. By defult this will give you incidents by day, but you can use the drill down feature to get this report in 5 minute intervals. (** If you don't like the drill down, you can recombine Date Only & 5 Min Time into a merged column also.. )
Thank You,
FOrrest
Helpful resources
Happy New Year from Power BI
This is a must watch for a message from Power BI!
Check it Out!
Click here to read the latest blog and learn more about contributing to the Power BI blog!
Get Ready for Power BI Dev Camp
Mark your calendars and join us for our next Power BI Dev Camp!.
