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 -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== 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!

[RogerStocker]

I really like your DAX routines to perform conditional formatting

[hariprasad]

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-music]

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.

[sibusisomani]

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

[sheilahart]

Your videos are great! Thank you Chandeep!🙂

[emilyamalkin]

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

[hichamezznati]

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
VAR END_DATE_PROJECT= SELECTEDVALUE(Data[End])
VAR CURRENT_DATE_MAX= MAX('Calendar'[Date])
VAR CURRENT_DATE_MIN= MIN('Calendar'[Date])
VAR _CONDITION = && END_DATE_PROJECT>= CURRENT_DATE_MIN
return
if(_CONDITION, "➖")

[jerrydellasala]

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

[thabodube]

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

[PurvaJain-yvst]

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 ?

[praveenkumar_]

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.

[achmadfarizky]

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

[atpuglinus]

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

[bones]

I'm getting a syntax error because I don't know what to put after "then Thelist"

[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?

[luisfernandomacedo]

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!!

[fabiozambelli]

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

[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.