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.
![ExcelData-22](https://msdynamicsnavashwinitripathi.files.wordpress.com/2015/10/exceldata-22.jpg)
![ExcelData-23](https://msdynamicsnavashwinitripathi.files.wordpress.com/2015/10/exceldata-23.jpg)
![ExcelData-24](https://msdynamicsnavashwinitripathi.files.wordpress.com/2015/10/exceldata-24.jpg)
Select City from Host & Sport from Medal Table. Apply Count (Not Blank) to Sport Field using dropdown list next to Field Name.
![ExcelData-25](https://msdynamicsnavashwinitripathi.files.wordpress.com/2015/10/exceldata-25.jpg)
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.
![ExcelData-26](https://msdynamicsnavashwinitripathi.files.wordpress.com/2015/10/exceldata-26.jpg)
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