You want to build a GANTT Chart, but not use any custom visual? In this video I show you how to turn a matrix into a GANTT with the help of some DAX and conditional formatting.
Enjoy the video and subscribe for more Power BI hacks!

Download file here https://datatraining.io/powerbihowto


TRAININGS

Power BI Design 4 Weeks Transformation Program https://my.datatraining.io/pages/powe...

Power BI Essentials https://datatraining.io/powerbilearni...

Business User Training https://datatraining.io/powerbibusin...

For Custom Trainings and Consulting email directly [email protected]


⏱ TIMESTAMPS ⏱

00:00 Intro
01:00 Step 1: Creating a bar chart as a base for the GANTT
01:56 Step 2: Creating a measure to indicate where the bars should be
04:53 Step 3: Apply conditional formatting to show bars
06:54 Step 4: Fixing columns
09:28 Step 5: Applying conditional formatting based on project status
13:23 Step 6: Fixing the tooltip
17:35 End


JOIN

Join https://bit.ly/4b453bi
Subscribe https://bit.ly/31MnQGO​
Insta   / howtopowerbi  
LinkedIn   / basdohmen  
TikTok   / how.to.power.bi  
X   / howtopowerbi  
fb   / howtopowerbi  
Threads https://www.threads.net/@howtopowerbi
Newsletter https://datatraining.io/newsletter


CHECK THIS OUT!

My gear https://amzn.to/47F21Yc
Power BI books MUST READ! https://amzn.to/3tUfFcj
General books I recommend https://amzn.to/48YNo33
Music for my videos https://www.epidemicsound.com/referra...
For growing on YouTube: https://www.tubebuddy.com/bas
Stuff I use daily https://amzn.to/3HqfMQ2

* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!

Thanks for being a part of this channel and all your support!

#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX