Home > Paul Mather, Work > #ProjectServer #PowerView report in #Excel 2013 #PS2010 #PS2013 #Office2013

#ProjectServer #PowerView report in #Excel 2013 #PS2010 #PS2013 #Office2013

Paul Mather
I am a Project Server and SharePoint consultant but my main focus currently is around Project Server.
I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011.
I am also a certified Prince2 Practitioner.

This article has been cross posted from pwmather.wordpress.com (original article)

This post will take a brief look at creating a map view of Project Server data – this does assume you tag your projects with a location!

For the purpose of this post I will use the example Excel file shown below – this pulls data from one of my test Project Server PWA instances, hence the project names!


In Excel 2013, click Insert > Power View Reports:


You will now see a Power View report:


To create a map with the projects plotted in the correct location by cost, see the steps below.

On the design tab, click Map and you will see the following:


Now click the map and modify the Power View fields shown below:


For this example, add ProjectCost to the size property, add Project Locations to the Locations property and set the colour property to ProjectName:


Increase the size of the map and add a title:


You can hover over the data circles and a tooltip will appear with the project details:


The data can be refreshed and the map updates.

A quick and simple report to show projects by location.

Categories: Paul Mather, Work Tags:
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: