Create a Project Overlapping Timeline Dashboard in Power BI

Рет қаралды 25,960

Күн бұрын

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 - goodly.wordpress@gmail.com
===== 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!

Пікірлер: 30

@GoodlyChandeep Жыл бұрын

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

@RogerStocker Жыл бұрын

I really like your DAX routines to perform conditional formatting

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

@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,"➖")

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

@sibusisomani1746 Жыл бұрын

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

@sheilahart7528 Жыл бұрын

Your videos are great! Thank you Chandeep!🙂

@emilyamalkin4367 Жыл бұрын

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

@AndyDevineUK Жыл бұрын

Thank You!!! This is great!!

@thabodube7856 10 ай бұрын

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

@jessicac9596 10 ай бұрын

Always fantastic! 😀

@jerrydellasala7643 Жыл бұрын

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

@carltonseymour869 Жыл бұрын

Thank you Chandeep

@josealvesferreira1683 8 ай бұрын

very good, thanks.

@PurvaJain-yv3st 2 ай бұрын

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

@achmadfarizky Жыл бұрын

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

@GoodlyChandeep Жыл бұрын

Glad it was helpful :)

@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

@sanumpzha Жыл бұрын

🤟

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

@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 28 күн бұрын

Send code