How to create a GANTT CHART to track project and tasks in Power BI using the default Matrix Visual

Get Demo Files here

In this video were going to cover how to create your very own Gantt Chart to track your project tasks using only the Matrix Visual.

-

🚩 Support us to get perks such as demo files, early access and more!

MY FAVOURITE POWER BI BOOKS

MY GEAR

GET IN TOUCH

🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of YouTube.

If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.

🐎 First, watch this video about how a typical Power BI workflow looks like

🗺 Learn DAX to extend your Power BI calculations

📆 Stay up-to-date on all the features Power BI releases monthly

🧪 Get certified as a Microsoft Data Analyst Associate

💡 Learn Power BI Features to improve your dashboards
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.

🔻 Get started with Power BI Desktop for FREE

#PowerBI #DataAnalytics #BusinessIntelligence

[magdalenaauer]

Thanks a lot - that really helped me!
Potential feedback you might want to consider: Adding a link to a document that contains the DAX, so people can copy paste the code and are even faster in implementing it in the measure field.
Great job!!!!

[devagunalan]

Brilliant. But the versions have changed since this video and it made it a little harder to follow

[ahmedkhalid]

Informative video. I have done the same steps but it says too many values in date value. And I have to visualise all dates. Any advice would be much appreciated

[gxvtumy]

Thanks a lot for this template
I have issue -- if apply data with time as start, end, duration
field use show in column in matrix not work!!, you can advice it?

[mategombas]

Hi there, very nice solution. My only complaint is when you want to use year or month in the column instead of days it falls apart. Simply ignoring starting and ending period or starting and ending year respectively thus resulting null instead of 1.

[patricioolivares]

Hi Fernan! Thanks a lot for the helpful video. This is a nice workaround to avoid custom visuals. Is there any chance that you can go one step further and teach us how to create a Gantt Chart using SVG objects in a measure and the matrix visual? I saw a snapshot of a table that includes baseline and current dates. Any advise will be much appreciated!

[surbhikshah]

hi can you show what exactly was in calendar table? I understand its connecting to using start date in project table but needed to know which columns are there

[benhayes]

Excellent Video. Easy to follow, thanks

[juansandoval]

Thank you for this demo. I had a question regarding an issue I'm having with it though. On the measure it seems to be only pulling either the min or max status, not the inbetween. Have you had issues with this before ? or do you have any idea what it could be?

[LNguyen-txse]

Great video, question: is there a way to remove the status from the matrix row but have a single line based on project that displays both all status within the calendar year? and also sort it based on starting date by project?

[amolupale]

This is great! QC is there a way to add data label to the columns (like the date on the bar)

[stoutis_tavern]

Hi, really nice solution, worked perfect for me, thank you very much!
Best regards

[muzinkuhlu]

You a rock star 💫 🎉. However, when collapsing to Months the Period is not accurate

[evandunn]

This is extremely helpful Fernan, thank you!

[redrum]

This is amazing! thanks! I have used this for resource tracking and i have replaced your 'Project' Column with 'Name' and your 'Task' Column with 'Projects so that I can see Names and the days where people are working on Projects. I have also replaced your 'Status column with 'Utilization count.

Would i then be able to add a new column for each name that aggregates the Utilization count for days where there is overlap of start and finish dates on the projects they are working on ? And IF the Utilization count is more than 1 for the days with overlaps then I would be able to condition format

[asharma]

Great video, thanks for sharing this. Can we also have Milestones on this report.

[harriewaasdorp]

The Collumn Values DAX formula gives me a 1 for the start en finish date, but for the values in between it creates a blank row on the top and puts a 1 there. Any solution to this?

[Adhbuthaha-ASR]

Can you able to develop the same with out adding the multiple rows but only one row which can be the current complete month day 1 to day max data.

[nghuwei]

Great content and thanks for sharing this tips. Been very useful for project management dashboard. Just one question, any idea if we can show all the task in same row but with different color? Assuming we have a standard set of tasks.

[SteffenTHughes]

i don't follow the logic in the return. i can't get 1's to show up. as in, all of my start dates are Greater than the min calendar date, so i am confused on how your earliest calendar date is GREATER than your start dates, and how the same with the end date. what kind of calendar do you have where your latest calendar date is less than your end date??