Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am new to Power BI., and I am lost at the moment. I need to make this data show in a power bi report as an hour/building
I need to see the check-ins by the hour for each building. I have grouped by building but still cannot figure out the best way to change the data to show by the hour for building?
Check In date | Check In Time | Building |
7/15/2022 | Ridgecrest North | |
7/15/2022 | Presidential II | |
7/15/2022 | 10:58:00 AM | Presidential I |
7/15/2022 | Ridgecrest West | |
7/15/2022 | Blount | |
7/15/2022 | Paty | |
7/15/2022 | 10:57:00 AM | Presidential I |
7/15/2022 | Riverside West | |
7/18/2022 | 1:33:00 PM | East Edge Apartments |
7/20/2022 | 11:00:00 AM | Bryant |
7/20/2022 | 5:01:00 PM | Mary Burke West |
7/20/2022 | 12:00:00 PM | Martha Parham East |
7/20/2022 | 10:54:00 AM | Lakeside West |
7/22/2022 | 9:38:00 AM | Tutwiler |
7/22/2022 | 9:37:00 AM | Tutwiler |
7/22/2022 | 9:35:00 AM | Tutwiler |
7/22/2022 | 10:04:00 AM | Tutwiler |
7/22/2022 | 10:12:00 AM | Tutwiler |
7/22/2022 | 9:55:00 AM | Tutwiler |
7/22/2022 | 10:20:00 AM | Tutwiler |
7/22/2022 | 9:50:00 AM | Tutwiler |
7/22/2022 | 10:24:00 AM | Tutwiler |
7/22/2022 | 9:34:00 AM | Tutwiler |
7/22/2022 | 10:22:00 AM | Tutwiler |
7/22/2022 | 9:49:00 AM | Tutwiler |
7/22/2022 | 9:28:00 AM | Blount |
7/22/2022 | 10:16:00 AM | Tutwiler |
7/22/2022 | 9:26:00 AM | Blount |
7/22/2022 | 10:00:00 AM | Tutwiler |
7/22/2022 | 9:43:00 AM | Tutwiler |
7/22/2022 | 9:41:00 AM | Tutwiler |
7/23/2022 | 1:00:00 AM | Ridgecrest North |
7/23/2022 | Presidential II | |
7/23/2022 | 1:30:00 PM | John England Jr. |
7/23/2022 | 8:00:00 PM | Mary Burke East |
7/23/2022 | Bryce Lawn | |
7/24/2022 | 6:00:00 PM | John England Jr. |
7/24/2022 | Presidential I | |
7/25/2022 | Bryce Lawn |
Solved! Go to Solution.
@bnpendley You could create a new custom column using Time.Hour and then group by date and hour?
@bnpendley You could create a new custom column using Time.Hour and then group by date and hour?