ฝัง
- เผยแพร่เมื่อ 14 ต.ค. 2024
- 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!
Download File ⬇ - goodly.co.in/how-create-project-overlapping-timeline-dashboard-power-bi
I really like your DAX routines to perform conditional formatting
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.
Your videos are great! Thank you Chandeep!🙂
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,"➖")
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.
Verry helpful, I used it on promotions that are overlapping.
So cool! I love your awesome videos, thank you so much!!! 👍🏻
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 ?
Always fantastic! 😀
Very cool (of course!). Is this even possible in Excel? Would love to see that.
Thank You!!! This is great!!
very good, thanks.
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.
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!
@@GoodlyChandeep Thank you so much!! 😊😊
1:57 what’s the last line of code for the If statement ?
Thank you Chandeep
Kindly share the dax details for measure of start project and end project
goodly.co.in/how-create-project-overlapping-timeline-dashboard-power-bi
Thank you very much. I really need this slicer trick for my personal project.
Glad it was helpful :)
🤟
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?
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.
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!!
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
Mi chiedo invece perché devi fare una masterclass se hai già delle rendite così remunerative.
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.
Send code