The Industry Portfolio Managers or Engineers struggle to manage multiple projects and get the best on the earned value on the Project profitability. Executing multiple projects without hassle requires a strong maintenance option and needs a specific detailed data fact with different project managers.
Being a trusted Microsoft power BI partner in UAE, we suggest the optimum methods to grab the best power BI Gantt charts for both Project Managers and Portfolio Managers. Power BI is a must visualization tool for every project manager should have to track the different Project.
Here is the Few configuration details for Portfolio Management
The Gantt Chart of Power BI displays the event along the particular timeline.
Here the Bar Chart is converted into a Gantt Chart.
The below is the bar chart that describes the Project Name and the corresponding duration.
The start date for each project varies to find that the minimum of each project is obtained through the measures.
Overall Start Date = calculate(MIN(Project[Start Date]),REMOVEFILTERS())
Project Start Date =
var startdate = CALCULATE (MIN(Project[Start Date]),REMOVEFILTERS(‘Date'[Date]))
INT (startdate – Project[Overall Start Date])
Now include the Project Start Date into the values of Bar Chart, which looks as below.
Now the exact duration is obtained. Now the light blue color has to be made invisible by formatting.
After formatting the Bar Chart Looks as below.
To make it better a line is added which represents today, done by using a measure.
today = INT( Today() – Project[Overall Start Date])
To add the constant line, choose it from further analyses part
Once formatting is done the Bar Chart turns into a Gantt Chart as below.
Please feel free to contact us for a quick demo. Peruteck Technology Services is a UAE based Microsoft Dynamics 365 Implementation partner specialized in modern digital transformation specialist with a wide range of experience in Dynamics 365 F&O, Dynamics 365 Sales, Dynamics 365 Field Service, Azure Data lake and Data Factory and Business intelligence partner in the UAE