Use hierarchies in PivotTables
In this post, we will create a Power View report to visually represent the Olympics data.
In Excel, click INSERT > Reports > Power View Reports.



Select City from Host & Sport from Medal Table. Apply Count (Not Blank) to Sport Field using dropdown list next to Field Name.

From design switch the Visualization to Map.
On the map, blue circles of varying size indicate the number of different sport events held at each Olympic Host location.

Drag Season Field to Color area. This will add different colors for different Seasons. In our case summer/Winter Red/Blue colors.
Just in few clicks now we have a Power View report that visualizes the number of sporting events in various locations, using a map, color-coded based on season.
Will come with more details in my upcoming posts, till then stay tuned, keep learning and practicing.
[…] Open the Excel Workbook we created in our earlier post. Create a Power View report […]
ReplyDelete[…] Open the Excel Workbook we created in our earlier post. Create a Power View report […]
ReplyDelete[…] Open the Excel Workbook we created in our earlier post. Create a Power View report […]
ReplyDelete[…] Open the Excel Workbook we created in our earlier post. Create a Power View report […]
ReplyDelete