In this tutorial, I will work through how you can create a Gantt Chart in Power BI using the matrix visual.
This is a very unique way in Power BI to create a visualization which represents time related information.
We work through how to create the right data model. The advanced DAX formula combination and also how to use conditional formatting inside the matrix visual.
Enjoy learning about Gantt Chart in this particular tutorial.
***** Video Details*****
2:04 - setting up the matrix
3:18 - establishing the table connections in the matrix
3:23 - creating a table for Days
4:21 - formula for Step 1
7:45 - creating a Gantt chart using the matrix
8:05 - conditional formatting
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-reference-guide-download
FREE – Power BI Resources - http://enterprisedna.co/power-bi-resources
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-dna-events-page/
*****Related Links*****
How To Create Compelling Reports & Dashboards In Power BI - https://blog.enterprisedna.co/2019/07/23/how-to-create-compelling-reports-dashboards-in-power-bi/
How To Use The Built-in Analytics For Power BI Scatter Charts - https://blog.enterprisedna.co/native-analytics-for-scatter-charts/
Power BI Data Visualization Tips For KPI Trends Analysis - https://blog.enterprisedna.co/power-bi-data-visualization-tips-for-kpi-trends-analysis/
*****Related Course Modules*****
Business Analytics Series - http://portal.enterprisedna.co/p/business-analytics-series
Unique Analytical Scenarios - http://portal.enterprisedna.co/p/unique-analytical-scenarios
Data Visualization Tips - https://portal.enterprisedna.co/p/data-visualization-tips
*****Related Forum Posts*****
Create A Gantt Chart In Power BI With A Matrix Visual - https://forum.enterprisedna.co/t/create-a-gantt-chart-in-power-bi-with-a-matrix-visual/4062
Project Management – Current & Next Milestones - https://forum.enterprisedna.co/t/project-management-current-next-milestones/6392/6
Analytics Function For Power BI Scatter Charts Review - https://forum.enterprisedna.co/t/analytics-function-for-power-bi-scatter-charts-review/610
For more gantt chart queries to review see here - https://forum.enterprisedna.co/search?q=gantt%20chart%20power%20bi