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

March 23, 2016 at 10:28 am | Posted in Add-on, Customisation, Functionality, Information, Reporting | 1 Comment
Tags: , , , , , , ,

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

https://app.powerbi.com/visuals/show/Gantt1448688115699

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:

https://pwmather.wordpress.com/tag/powerbi/

Advertisements

1 Comment »

RSS feed for comments on this post. TrackBack URI

  1. Awesome, looks great and nice description on how to use it!


Leave a Reply

Fill in your details below or click an icon to log in:

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

Blog at WordPress.com.
Entries and comments feeds.

%d bloggers like this: