Create a Project Overlapping Timeline Dashboard in Power BI

In this video tutorial, I will guide you through the process of creating a visually engaging and interactive project overlapping timeline dashboard using Power BI.
You will learn how to prepare your data, apply Dax and visualization tricks, and set up slicers to highlight overlapping months for each project between the start and end dates. By the end of the video, you will have the skills to create your own custom interactive dashboards in Power BI.
#powerbi #datavisualization #dashboardtutorial #daxtricks
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/l...
✔️ Power Query Course-
goodly.co.in/l...
✔️ Master Excel Step by Step-
goodly.co.in/l...
✔️ Business Intelligence Dashboards-
goodly.co.in/l...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co....
Corporate Training 👨‍🏫 - www.goodly.co....
Need my help on a Project 💻- www.goodly.co....
Download File ⬇️ - goodly.co.in/h...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - [e-mail]
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

[@GoodlyChandeep]

Download File ⬇ - goodly.co.in/how-create-project-overlapping-timeline-dashboard-power-bi

[@hariprasad289]

The way of representation using this matrix, highlight selected row based on the slicer selection, overlapping concepts are very interesting and useful. Thank you Chandeep.

[@Feel-the-music333]

thank you very much. Suppose what if i have Project name, planned start date, planned end date, actual start date, actual endate. Now i need to show Planned vs Actual.

[@hichamezznati2646]

Great video as always . thanks a lot . here is an other way to get the same result using dax only ( and withoud necessarily connecting calendar table to Data table ) Measure= VAR START_DATE_PROJECT=SELECTEDVALUE(Data[Start]) VAR END_DATE_PROJECT= SELECTEDVALUE(Data[End]) VAR CURRENT_DATE_MAX= MAX('Calendar'[Date]) VAR CURRENT_DATE_MIN= MIN('Calendar'[Date]) VAR _CONDITION = START_DATE_PROJECT= CURRENT_DATE_MIN return if(_CONDITION,"➖")

[@thabodube7856]

1:57 what’s the last line of code for the If statement ?

[@sheilahart7528]

Your videos are great! Thank you Chandeep!🙂

[@emilyamalkin4367]

So cool! I love your awesome videos, thank you so much!!! 👍🏻

[@RogerStocker]

I really like your DAX routines to perform conditional formatting

[@PurvaJain-yv3st]

Hi.. I am working on a project related to creating Calendar table . I am watching your video s but I am stuck at certain points. I need to join your channel so that I can ask the queries. Is there any way to connect ?

[@jerrydellasala7643]

Very cool (of course!). Is this even possible in Excel? Would love to see that.

[@jessicac9596]

Always fantastic! 😀

[@praveenkumar_0143]

I am currently in a journey of becoming a power Bi developer and it's been a year I have explored right from Power query to Bi service. Need your inputs on how much level of understanding needed on M language and Dax for a fresher. Especially in current market situation.

[@GoodlyChandeep]

Keep it simple, Praveen! Understand the concepts and keep learning. There's no set number. Learn as much as you're interested in. Good luck on your Power BI journey!

[@praveenkumar_0143]

@@GoodlyChandeep Thank you so much!! 😊😊

[@josealvesferreira1683]

very good, thanks.

[@achmadfarizky]

Thank you very much. I really need this slicer trick for my personal project.

[@GoodlyChandeep]

Glad it was helpful :)

[@sanumpzha]

🤟

[@luisfernandomacedo1451]

Does your Power Query course cover the fundamentals, and code development at the level we took a glance at on this video? Thanks for sharing!!

[@GoodlyChandeep]

The current Power Query course is mostly exploring and solving the problems using the UI. A new M Language course is going to be out by next month end (which will cover things way beyond this video's complexity). Hope that helps

[@mienzillaz]

Why bother generating dates in between?? That is waste of space. Just drop the relation to calendar and do the checks for staring and ending dates against min and max dates. For overlap it's even easier. Wrap project in ALL and then do same checks for dates against slicer selection (additional table based on mian project db). Multiply results by earlier check to make second valid when first one returns 1. Third step is highlighting project that was selected on slicer. Again easy, just compare selected values from two tables and again multiply it by first check. Confused, write back and I will send sample.

[@kumaraswamyreddy2144]

Send code

[@sibusisomani1746]

Verry helpful, I used it on promotions that are overlapping.

[@atpuglinus]

Kindly share the dax details for measure of start project and end project

[@GoodlyChandeep]

goodly.co.in/how-create-project-overlapping-timeline-dashboard-power-bi

[@fabiozambelli1913]

Mi chiedo invece perché devi fare una masterclass se hai già delle rendite così remunerative.

[@AndyDevineUK]

Thank You!!! This is great!!

[@carltonseymour869]

Thank you Chandeep

[@nlagreste]

It is a very good solution, but when you work with millions of records it stops working and the performance is not good. For these cases what would you recommend?

[@snackymcgoo1539]

I would say figure out a way to change this from dynamic ram, and perform a cross join upstream in TSQL to achieve same result. Unfortunately the load of the additional records will take longer, but the dashboard would perform better. Actually, I don't know, the list approach here is the same as a cross join in tsql, performance would be bad either way. I have encountered this in other applications of cross join, not for this purpose in the video but other purposes.