Home > Paul Mather, Work > #PowerBI Gantt visualization #PPM #ProjectOnline #PMO #BI

#PowerBI Gantt visualization #PPM #ProjectOnline #PMO #BI

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)

A quick post to highlight a cool new custom visual for Power BI that was released a few weeks ago, the Gantt visualization. This can be downloaded from the link below:

http://bit.ly/1S5CWYF

Once added to Power BI Desktop this visual can be used in your Power BI reports. Below is a simple example that uses the Project Online Odata API to pull in the Project Name, Project Start Date, Project Duration and % complete:

image

In the example above I have also included some other project level custom fields, one to filter the data with a slicer and one to control the colour of the project bars. There are tooltips on the project / task bars to show details:

image

It also includes a “Today” line by default:

image

The Gantt visualization has some configurable settings that can be found on the visualizations pane:

image

You can control many formatting settings such as the date type:

image

Download and take a look to build some cool project center / project detail schedule type views in Power BI! For other Power BI posts for Project Online / Microsoft PPM, see the link below:

http://bit.ly/1LGjqW3

Advertisements
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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: