Using Power Query,Split & Merge Time Column into Hour(AM/PM) column | Create a Stunning Report Page✨
In this video we will be using the real world dataset.
311 Services Requests , Little Rock ,AR USA.
1) We will first use Power Query Editor to do a few transformations.
2) Using Power Query, Split & Merge Time Column into Hour(AM/PM) column
3) There are several ways you can compute count of events by the hour(AM/PM)
4) For example: by creating measures and/or calculated column etc.,
5) However the method has been simplified by using Power Query.
6) Create a report page that contain interactive visual.
Dataset: https://data.littlerock.gov/stories/s...
TIMESTAMPS
00:05 Transformations using Power Query
01:45 Start building the report page
02:15 Stacked Column chart
03:02 Add value to Legend field
03:13 Overview of the report page & Conclusion