#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: PowerBI, Project 2013, Project 2016, Project Online, Project Server 2013, Project Server 2016, PS2013, PS2016

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:

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:

It also includes a “Today” line by default:

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

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

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