Power View is another add-on on Microsoft Office Excel and part of Power BI. You can find the option under Insert –> Power View. (You might need to install Microsoft Silverlight first). Power View will load in a new Work Sheet.
In the article about Power Pivot I have create a Report using data from Dynamics NAV I’ll show you how to use this in Power View. For the explanation about Power Pivot go to: Getting Started with Power Pivot.
As you can see you can select data from the right panel and add it to the worksheet. In this Report we want to visualize the data from the Sales Revenue report (which is explained in the article “Getting Started with Power Pivot”). This we will do by creating a map and show the Sales Revenue per country. See below the Revenue Overview dashboard we created.
It shows the customers and their revenue, a map with revenue per country and the same information in a horizontal graph.
Ok, how to make this. The necessary variables for this overview are Sales LCY which are the values and the Country/region code. The first step is to drag the field Country_Region Code to the Power View area (1). This will create a list with country codes. When you click on the button Map (2), the list will convert into a Bin map showing the locations.
When you add the field Sales LCY (Revenue), we see that the map shows circles with size depending on the amount of revenue per country.
Adding another chart works the same way. Drag the Country_Region code a second time to the Power View area. Add Sales LCY to the same table and choose Column Chart. Same works for the Customer table. The result shows:
This is of course a basic report, but you can add slicers, pictures etc.
One of the neat functions here is if you for example click in the Chart on the bar NL, the map highlights the Revenue in NL and shows only the Customers located in NL.
Leave a Reply