Create A Gantt Chart In Power BI With A Matrix Visual
Вставка
- Опубліковано 23 лип 2024
- In this tutorial, I will work through how you can create a Gantt Chart in Power BI using the matrix visual.
This is a very unique way in Power BI to create a visualization which represents time related information.
We work through how to create the right data model. The advanced DAX formula combination and also how to use conditional formatting inside the matrix visual.
Enjoy learning about Gantt Chart in this particular tutorial.
**** Video Details****
2:04 - setting up the matrix
3:18 - establishing the table connections in the matrix
3:23 - creating a table for Days
4:21 - formula for Step 1
7:45 - creating a Gantt chart using the matrix
8:05 - conditional formatting
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ulti...
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-...
FREE - Power BI Resources - enterprisedna.co/power-bi-reso...
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - enterprisedna.co/enterprise-d...
****Related Links****
How To Create Compelling Reports & Dashboards In Power BI - blog.enterprisedna.co/2019/07...
How To Use The Built-in Analytics For Power BI Scatter Charts - blog.enterprisedna.co/native-...
Power BI Data Visualization Tips For KPI Trends Analysis - blog.enterprisedna.co/power-b...
****Related Course Modules****
Business Analytics Series - portal.enterprisedna.co/p/busi...
Unique Analytical Scenarios - portal.enterprisedna.co/p/uniq...
Data Visualization Tips - portal.enterprisedna.co/p/dat...
****Related Forum Posts****
Create A Gantt Chart In Power BI With A Matrix Visual - forum.enterprisedna.co/t/crea...
Project Management - Current & Next Milestones - forum.enterprisedna.co/t/proj...
Analytics Function For Power BI Scatter Charts Review - forum.enterprisedna.co/t/anal...
For more gantt chart queries to review see here - forum.enterprisedna.co/search... - Розваги
*****Related Links*****
How To Create Compelling Reports & Dashboards In Power BI - blog.enterprisedna.co/2019/07...
How To Use The Built-in Analytics For Power BI Scatter Charts - blog.enterprisedna.co/native-...
Power BI Data Visualization Tips For KPI Trends Analysis - blog.enterprisedna.co/power-b...
*****Related Course Modules*****
Business Analytics Series - portal.enterprisedna.co/p/busi...
Unique Analytical Scenarios - portal.enterprisedna.co/p/uniq...
Data Visualization Tips - portal.enterprisedna.co/p/dat...
*****Related Forum Posts*****
Create A Gantt Chart In Power BI With A Matrix Visual - forum.enterprisedna.co/t/crea...
Project Management - Current & Next Milestones - forum.enterprisedna.co/t/proj...
Analytics Function For Power BI Scatter Charts Review - forum.enterprisedna.co/t/anal...
For more gantt chart queries to review see here - forum.enterprisedna.co/search...
I really like these non-finance reports youre creating videos on! Keep it up! :)
This is amazing I must say. You just gave me some ideas to work on my next report. Thank you for the great content.
Hi aduck24, great that you found value in this video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: ua-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
This is sooooo cool. Innovating through power BI. Well done mate.
Hi Kevin Harilal, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials.
Here’s the link: ua-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Very great idea. Have you got the Pbix file? as not all the steps were shown in the video
Good stuff! FYI I had to change the formular for the ProjectDays variable to use DATEDIFF. Not sure why the syntax above didn't work for me. But all good! Cheers....
Its very insightful and interesting. I have an issue when i drag "Days" into the column tab, it does not show anything while i have used "Step1 formula". I suppose to have no issue . Can anyone share the Pbix. file please. thank you!
Fun trick I added to this one, I was able to zoom in/out by creating a multiplier for the Days field. So given 100 columns...if one cell equals 1 days, then the zoom level is 100 days. If the multiplier is set to "2", it zooms out to where each cell equals 2 days instead of one, so the zoom level is 200 days. You can go out as far as you want, but I stopped at 800 days.
Works for smaller ranges as well, if you set the multiplier to .5, then two cells equals one day, so the range is 50 days.
Hope that makes sense. It was pretty easy to create a zoom slicer to go along with.
I also had an interesting challenge to get my agile project work items to display correctly, since Epics, Features, User Stories, and Tasks can all have start and end dates that are somewhat independent, as opposed to rolling up to summary tasks.
Anyway, this video really got me started with the initial concept. I only wish I had the creative and graphic design skills to make mine more visually appealing.
Cheers and thanks again. If I can get my company to swing it, maybe I'll join up soon.
I am definitely interested in how you went about doing this.
I finally figured out how you did this...
1. Created a table 'Multiplier' with the following column [Factor] = GENERATESERIES(1,10,1)...Factor of 10.
2. Created a measure in the Days table [NewDays] = MAX(Days[Days]) * MIN('Multiplier'[Factor])
3. Adjusted the Step 1 measure...VAR CurrentDay = Days[NewDays]
4. Setup a slider for the Factor column
Voila
That's Fantastic!! Is it available to be downloaded in your website ?
I'm curious, I don't suppose there is a way to overlay text labels on the visual?
Add conditional formatting -> Icons -> Icon Layout/Icon only and change the icon for values 0 and 1 to ‘No Icon’ to eliminate the 0s and 1s.
Thanks for the suggestion, Steve!
Hi Sam! Nice solution, as always! However I think Power BI at this moment is not the best in visualizing multiple dates per category (e.g.: Gantt chart). There are some custom visuals out there on the market place, but none of them are that good. Tableau for example can do such visuals, but Power BI is lacking them and I can see kind of big business demand for such representations. Hopefully they will release something for that.
Hi Sam. Awesome video. A complete newbie undertaking my first PowerBI task and I've got my gantt chart happily up and running! Just wondering if there's any way to manage the values/conditional formatting when you 'roll up' to the Project 1, Project 2, etc. level? When I do that I just return 0 values for all my cells and get no coloured lines. Appreciate any help!
Impressive. Would like to know jhow you enable the conditional formatting for those different task types.
Thank you.
Hi Vinod, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!
Perfecto!!!
Hi Roberth, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials and announcements. Cheers!
Cool
Question. This looks good, but you only have a Gantt chart 100 days? Does that mean a matrix can't hold more than 100 values? i.e. useless for projects longer than 100 days if you want to show day values.
@Enterprise DNA how is the date slicer set up? What field are you using?
Hi Lori, find all forum posts on setting up data slicer here:
forum.enterprisedna.co/search?q=set%20up%20data%20slicer
How about drilling up to months or quarterly? This is awesome by the way!!
Hi Philip Emmanuel,
Gantt chart is useful towards Daily level instead of of Monthly/Quarter.
One can Drill up to Month/Quarterly level but it won't provide much insight.
For any special requirements, please explore EDNA Forum forum.enterprisedna.co/
Love the video, Just subscribed! Is there a way to export a table to showw the values that are 0 per project?
Hello Ethan,
Thank You for posting your query onto our channel.
Well just click onto the visual to activate that chart and than in the top-right corner click onto the 3 dots ellipsis and from the drop-down bar either select the option of "Export Data" and "Show as a Table" and than you can analyze the results the way you're looking for.
For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as well experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference.
Hoping you find this useful and meets your requirements that you've been looking for.
Happy Learning!!!
forum.enterprisedna.co/
After setting up my Gantt in matrix style table, i have one more issue to solve: how to show real date somewhere above or bellow the Step 1 series? Now i have 1,2,3,4,5,6,7.... but don't know which date is behind these numbers. Thanks!
Chocho, where you able to find a solution for the real date?
I'm going to use this method fow showing when staff are taking vacation in the visual
Hi Sam Hall, Glad you find the video helpful. We are so grateful to have had such positive feedback.
hey, I was curious to know, whether we can link up the activities in a Power BI Gantt Chart?
Hello ma minhaj,
thank you for posting your query onto our channel.
Well your query is not quite specific and therefore we're not in a position to judge and provide you the results efficiently.
We encourage you to please write back to us again onto our Community Forum by providing the description of the problem that you're facing along with the working of the PBIX file as well as the mock-up of the results that you're trying to achieve where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference.
Hoping you find this useful.
Happy Learning!!!
forum.enterprisedna.co/
I have to perform a drill through that should take me to another page and display one Gantt chart (out of two) as per the selection. Can you pls advise?
Hello Jyoti Datta,
Thank You for question. We appreciate your time.
Drill-through option doesn't replace one chart with another. It's used to show the part of that data. In order to achieve the results based on the scenario that you've specified, you can try the option of either "Bookmarks" or "Page Navigator".
We're providing few of the links of the videos from our Enterprise DNA UA-cam channel pertaining to this topic.
ua-cam.com/video/HH40GqCJ2ug/v-deo.html
ua-cam.com/video/GruF4juSB-w/v-deo.html
blog.enterprisedna.co/power-bi-page-navigation-updates-tutorial-review/
ua-cam.com/video/Ey1X-x4DG0Q/v-deo.html
ua-cam.com/video/kjaZtYkubjA/v-deo.html
ua-cam.com/video/8bpNPB4SPSg/v-deo.html
For more queries, you can also reach out to us through our Community Forum where our members as well as Experts Team will be able to assist you, in a better and efficient manner.
I hope this helps.🙂
Please make sure that you're subscribed to our UA-cam channel so you don't miss out any updates regarding Power BI. Along with it, you may also be interested to join our Power BI group on LinkedIn to receive latest updates. Links provided below for your reference.
Happy Learning!!!
Thanks and Warm Regards,
Enterprise DNA
forum.enterprisedna.co/
ua-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
www.linkedin.com/groups/12004506/
Thanks for great Idea ,If still available, I need your sheet data and Report.
Hi Omnia, glad that you found value in this video. All pbix file/datasets are available for download in the Enterprise DNA Online, which is accessible via Membership. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!
portal.enterprisedna.co/
This is a beautifully designed report, however I wish you had let me know that Power BI's Matrix visual has a limit of 100 columns as I've spent they day trying to build out a similar asset utilization daily chart for a full calendar year. I'm going to have to adjust it to show by week instead of by day. Great video. Thanks for posting.
Hi MissingVanSushi, glad that you found value in this video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!
@@EnterpriseDNA Thank you. I changed it to a weekly chart and it looks great. Thanks for showing the way!
@@adrianjliu Can you explain how you changed it to a weekly chart. I want to create the same, but in a Monthly or quarterly chart.
This is very good. In Step 1 measure you have Value [Selected Date], where you got this from?
Do you have the .pbix example file for this tutorial?
I made a measure [Selected Date] and I try to use it but unfortunately with no success, then I have replaced [Selected Date] with Today() and it works, but just from today. My Step 1 measure look like this:
Step 1 =
VAR CurrentDay = MAX( Days[Days] )
VAR ProjectDays = MAX( 'Project Data'[End Date] ) - MAX( 'Project Data'[Start Date] )
VAR DaysFromStartDate = MAX( 'Project Data'[Start Date] ) - VALUE( TODAY())
VAR DaysFromEndDate = DaysFromStartDate + ProjectDays
RETURN
If(
AND( CurrentDay >= DaysFromStartDate ; CurrentDay
@@UltrashockChannel what was the formula [selected day] you used?
@@marounsader318
Selected Date =
DATEDIFF ( MIN ( 'Date'[Date]); MAX ( 'Date'[Date] ); DAY )
To use this you need Date table, which is easy to create: in Query Editor add new Blank Query and then in the Advanced Editor put this code, then just use the function to set Start and End Date, then Invoke. After doing this you will have a new table called Invoked function which you can rename to Date. Here is the code for Advanced Editor :
let CreateDateTable = (StartDate as date, EndDate as date, optional Culture as nullable text) as table =>
let
DayCount = Duration.Days(Duration.From(EndDate - StartDate)),
Source = List.Dates(StartDate,DayCount,#duration(1,0,0,0)),
TableFromList = Table.FromList(Source, Splitter.SplitByNothing()),
ChangedType = Table.TransformColumnTypes(TableFromList,{{"Column1", type date}}),
RenamedColumns = Table.RenameColumns(ChangedType,{{"Column1", "Date"}}),
InsertYear = Table.AddColumn(RenamedColumns, "Year", each Date.Year([Date])),
InsertQuarter = Table.AddColumn(InsertYear, "QuarterOfYear", each Date.QuarterOfYear([Date])),
InsertMonth = Table.AddColumn(InsertQuarter, "MonthOfYear", each Date.Month([Date])),
InsertFinYearNumber = Table.AddColumn(InsertMonth, "FinYearNumber",each if [MonthOfYear] >= 7 then [Year] else [Year] -1 ),
InsertFinYearDisplay = Table.AddColumn(InsertFinYearNumber, "FinYear" ,each "FY" & Text.End(Number.ToText([FinYearNumber],"D",""),2) & "/" & Text.End(Number.ToText([FinYearNumber]+1,"D",""),2)),
InsertFinMonth = Table.AddColumn(InsertFinYearDisplay, "FinMonth", each if [MonthOfYear] >= 7 then [MonthOfYear] - 6 else [MonthOfYear] + 6 ),
InsertFinQuarterNumber = Table.AddColumn(InsertFinMonth, "FinQuarterNumber", each if [QuarterOfYear] > 2 then [QuarterOfYear] -2 else [QuarterOfYear] + 2),
InsertFinQuarterDisplay = Table.AddColumn(InsertFinQuarterNumber ,"FinQuarter", each "FQ" & Number.ToText([FinQuarterNumber],"D","") ),
InsertDay = Table.AddColumn(InsertFinQuarterDisplay , "DayOfMonth", each Date.Day([Date])),
InsertDayInt = Table.AddColumn(InsertDay, "DateInt", each [Year] * 10000 + [MonthOfYear] * 100 + [DayOfMonth]),
InsertMonthName = Table.AddColumn(InsertDayInt, "MonthName", each Date.ToText([Date], "MMMM", Culture), type text),
InsertCalendarMonth = Table.AddColumn(InsertMonthName, "MonthInCalendar", each (try(Text.Range([MonthName],0,3)) otherwise [MonthName]) & " " & Number.ToText([Year])),
InsertCalendarQtr = Table.AddColumn(InsertCalendarMonth, "QuarterInCalendar", each "Q" & Number.ToText([QuarterOfYear]) & " " & Number.ToText([Year])),
InsertDayWeek = Table.AddColumn(InsertCalendarQtr, "DayInWeek", each Date.DayOfWeek([Date],1)+1),
InsertDayName = Table.AddColumn(InsertDayWeek, "DayOfWeekName", each Date.ToText([Date], "dddd", Culture), type text),
InsertWeekEnding = Table.AddColumn(InsertDayName, "WeekEndingFriday", each Date.EndOfWeek([Date],6), type date),
InsertCurrentThursday = Table.AddColumn(InsertWeekEnding, "CurrentThursday", each Date.AddDays([Date], -Date.DayOfWeek([Date],1) + 3), type date),
InsertISOWeekJan4 = Table.AddColumn(InsertCurrentThursday, "ISOWeekJan4", each Date.FromText(Number.ToText(Date.Year([CurrentThursday])) & "-01-04") ,type date),
InsertISOWeekYear = Table.AddColumn(InsertISOWeekJan4, "ISOWeekYear", each Date.Year([CurrentThursday])) ,
InsertISOWeekFirstMon = Table.AddColumn(InsertISOWeekYear, "ISOWeekFirstMon", each
if [CurrentThursday] < [ISOWeekJan4]
then Date.AddDays([CurrentThursday],-3)
else Date.AddDays([ISOWeekJan4], - Date.DayOfWeek([ISOWeekJan4],1) )
,type date),
InsertISOWeekNum = Table.AddColumn(InsertISOWeekFirstMon, "ISOWeekNum", each Number.RoundUp(((Duration.Days(Duration.From([Date] - [ISOWeekFirstMon]))+1) /7 )), type number),
InsertISOWeekID = Table.AddColumn(InsertISOWeekNum, "ISOWeekID", each [ISOWeekYear] * 100 + [ISOWeekNum], type number),
InsertISOWeekName = Table.AddColumn(InsertISOWeekID, "ISOWeekName", each Text.From([ISOWeekYear]) & "W" & Text.End( "0" & Text.From(([ISOWeekNum]*10) + [DayInWeek]),3)),
InsertISOWeekNameLong = Table.AddColumn(InsertISOWeekName, "ISOWeekNameLong", each Text.From([ISOWeekYear]) & "-W" & Text.End( "0" & Text.From([ISOWeekNum]),2) & "-" & Text.From([DayInWeek])),
fnPeriod445a = (weekNum) => let
Periods =
{
{(x)=>xxxxxxxxxxxtrue, [P=12,Q=4]}
},
Result = List.First(List.Select(Periods, each _{0}(weekNum))){1}
in
Result,
InsertPeriod445 = Table.AddColumn(InsertISOWeekNameLong, "Period445Record", each fnPeriod445a([ISOWeekNum])),
ExpandPeriod445 = Table.ExpandRecordColumn(InsertPeriod445, "Period445Record", {"P","Q" }, {"Period445", "Quarter445"}),
RemovedColumns = Table.RemoveColumns(ExpandPeriod445,{"CurrentThursday", "ISOWeekFirstMon"})
in
RemovedColumns
in
CreateDateTable
@@UltrashockChannel Awesome!
@@UltrashockChannel This needs more appreciation, very helpful, thank you. I you ever are close to Grapevine TX let me invite you a beer.
How do you also display the project summary tasks in the Gantt Chart in Power BI?
Hello Dan,
Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it.
Well it's always a little bit difficult to judge and provide the results without looking at the data structure, model and working of the PBIX file for the reference.
And therefore we encourage you to please write back to us onto our Community Forum by providing the proper description of the problem that you're facing along with the PBIX file for the reference as well as the mock-up results that you're trying to achieve where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference.
Hoping you find this useful. Subscribe to our UA-cam channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes.
Cheers,
Enterprise DNA
forum.enterprisedna.co/
ua-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
www.linkedin.com/groups/12004506/
De onde achou esse select valor da fórmula ?? Aula tinha tudo para ser a melhor, mas isso aí travou para quem esta aprendendo. Valeu pela tentativa
Mano, eu tbm me bati atrás disso aí e percebi que o cara não está mt afim de ajudar, mas é simples de resolver, Coloca por exemplo entre os parênteses a data mínima que você deseja contabilizar o Gantt, no meu caso eu fiz VALUE("01/01/2022") e deu certo!
is there any way to add more fields as tooltip to matrix?!?
Hi bahman7210,
Microsoft Updated the way that tooltips work. It depends what you are wanting to place in the tooltip.
There are a number of videos available online that cover this.
ua-cam.com/video/URTA7JZsAtw/v-deo.html
Be sure to check out the forum were a member shared a great trick which you could extend.
forum.enterprisedna.co/t/tip-show-dax-formula-in-a-tooltip/5875
Regards,
Enterprise DNA
Can I create a slicer or some kind to change the start date or duration of each task? or at least the first task?
Hello Shamsul Ramli,
Thank you for posting your query onto our channel.
Well, in the video it's already shown onto the report interface that it contains the slicer at the top right hand-side corner to change the start date or duration of each task so we're not sure what you're trying to highlight here or the results that you're trying to achieve.
And we request you to please write back to us onto our Community Forum by elaborating your query along with the required files attached by providing the description of the problem that you're facing and the results that you're trying to achieve where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference.
Hoping you find this useful and helpful. Also, make sure that you're subscribed to our UA-cam channel so that you don't miss out on any updates pertaining to the Power BI.
Cheers,
Enterprise DNA
forum.enterprisedna.co/
ua-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
how do you connection project start date and end date to the 'dates' table?
Hello Wasita Witchutraiphob,
Thank you for posting your query onto our channel. We really appreciate you taking your precious time to post your query on it.
Well, the connection is created indirectly within the measures itself since there're multiple date fields as showcased into the video.
For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
Hoping you find this useful. Also, make sure that you're subscribed to our UA-cam channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes.
Cheers,
Enterprise DNA
forum.enterprisedna.co/
ua-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
www.linkedin.com/groups/12004506/
Can you please tell me in the third line of you Step 1 Measure what [Selected Date] refers to as I am getting an error saying it cannot be determined?
VAR DaysFromStartDate= MAX(Main_BUP_Data[Actual Start Date])- VALUE([Selected Date])
Hello Andrea,
Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it.
"Selected Date" is a measure in our report. Below is the code provided for the reference -
Selected Date = MIN( Dates[Date] )
For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
Hoping you find this useful! You can subscribe to our UA-cam channel so that you won't miss out on any Power BI updates. You can also join our LinkedIn group to receive latest updates on Power BI.
Cheers,
Enterprise DNA
forum.enterprisedna.co/
ua-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
www.linkedin.com/groups/12004506/
Hello, What do you mean with VALUE([Selected Date]) dax show me an error
Hello Felipe Avalos,
thank you for posting your query onto our channel.
Well, we're not sure what sort of error you're facing. And it's always a little bit difficult to judge and provide the results without looking at the data structure, model and working of the PBIX file for the reference.
The only thing we can say is that, VALUE() function converts a string of text into a number. So in this case, we converted the data into a number and than subtracted that number from the MAX( 'Project Data'[Start Date] ).
And therefore we encourage you to please write back to us onto our Community Forum by providing the proper description of the problem that you're facing along with the PBIX file for the reference as well as the mock-up results that you're trying to achieve where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference.
Hoping you find this useful.
Happy Learning!!!
forum.enterprisedna.co/c
If anyone is struggling with the connection between your Dates table and your main data table, connecting on the Date on your End Date should do the trick for the slicer.
Hello Matthew,
Thank you for posting your precious suggestion onto our channel. We really appreciate you taking your valuable time to post it.
In case of any queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
Hoping you find this useful. Also, make sure that you're subscribed to our UA-cam channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes.
Cheers,
Enterprise DNA
forum.enterprisedna.co/
ua-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
www.linkedin.com/groups/12004506/
in the 'step 1' you can metric custom measure 'selected date' ? how do you create that
Hello Wasita Witchutraiphob,
Thank you for posting your query onto our channel and we really appreciate you taking your time to post it.
Well, it's a small simple measure. Below it's provided for the reference -
Selected Date = MIN( Dates[Date] )
For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
Hoping you find this useful. Also, make sure that you're subscribed to our UA-cam channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes.
Cheers,
Enterprise DNA
forum.enterprisedna.co/
ua-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
www.linkedin.com/groups/12004506/
Hi
Is thyere a place where one could download the complete template of this Gantt using the Matrix Visual?
Hi Klaus,
Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it.
Well, one can download the template of a Gantt Chart for their perusal from our resources section but currently that's available only to the members who have purchased our entire course or specific set of course wherein they can access our resources templates.
For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
Hoping you find this useful. Also, make sure that you're subscribed to our UA-cam channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes.
Cheers,
Enterprise DNA
forum.enterprisedna.co/
ua-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
www.linkedin.com/groups/12004506/
Hi
I'm having issues with the [Selected Date] Measure on this video - Can anyone suggest resolution?
Hi Alex, can you explain the issue further to help us better understand? Thanks!
@@EnterpriseDNA sorry should've have given details! When I use that variable I'm getting an error, as if it's not been defined/exists anywhere. I'm not able to get a screenshot right now but will have one in a couple of hours
@@EnterpriseDNA Hi The error is "Cannot find [Selected Date]" - I've managed to follow the tutorial to the point where you drag Days into the column field and get the error - and then when doing Step 1 Formula i get the cannot find error
Can you share creating a table for Dates
Hi Krish, you can check out the tutorial we have on creating a date table here: ua-cam.com/video/NAghaFGXVFE/v-deo.html
How do you get "Selected Date"? Isn't a field in your date
Hello Gerardo,
That field has been converted into a measure and that measure is being referenced in our Gantt Chart. Below is the measure for the selected date provided for the reference -
Selected Date = MIN( Dates[Date] )
For furthermore queries, you can also reach out to us onto our Community Forum by providing a proper description of the query along with the reference mock-up files to work on, where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
Hoping you find this useful! If you haven't yet, you can subscribe to our UA-cam channel so that you won't miss out on any Power BI & Power Platform updates. You can also join our LinkedIn group to receive latest updates on Power BI.
Cheers,
Enterprise DNA
forum.enterprisedna.co/
ua-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
www.linkedin.com/groups/12004506/
Is it possible to further divide it into hours and minutes
Hello Arpit,
Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post.
Well, yes it's possible to further bifurcate it into hours and minutes provided proper or right logic entered into the measure.
For furthermore queries, you can also reach out to us onto our Enterprise DNA Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner.
Hoping you find this useful. Also, make sure that you're subscribed to our UA-cam channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes.
Cheers,
Enterprise DNA
forum.enterprisedna.co/
ua-cam.com/users/EnterpriseDNA
www.linkedin.com/groups/12004506/
Hi, I am a beginner in Excel & PBI, can you share the input Excel that is needed, for eg. what aOR how the dates/days are input. Anyone who interested to give some input is much appreciated as well. This is for my personal project. thanks
Hi Asraff, all pbix file/datasets/resource files are available for download in the Enterprise DNA Online, which is accessible via Membership. Check out the link below. Cheers!
portal.enterprisedna.co/
You dont explained how to create [Selected Dated] measure :(
Hi Ivan,
Selected Date = MIN( Dates[Date] )
For In-Depth insights on Project Management and lots other showcases present at enterprisedna.co/power-bi-showcase , explore EDNA Membership.
@@EnterpriseDNA HI, could you please clarify here with 'Dates'[Date] table . On the video Dates table has no active relationships with tables 'Days' or 'Project Data' ? The problem is to connect Selected Date used on the canvas Filter with the formula in demo . 'Selected Date' needs to be connected to Days (moving array) . Currently the solution does not work with " Selected Date = MIN( Dates[Date] ) "
@@eugena4675 Same here. I like the video, but can't help but feel like the whole thing is useless without having clarity on crucial aspects of what makes the whole thing work.
Hi
Sam I am a member of Enterprise DNA, But cannot find a place to drop a msg for u, need to work out weeks instead of Days facing difficulties can u help
Very great idea. Have you got the Pbix file? as not all the steps were shown in the video
Hi Taha Hafiz, thanks for posting your comment in the video. All pbix file/datasets/resource files are available for download in the Enterprise DNA Online, which is accessible via Membership. Check out the link below. Thanks!
portal.enterprisedna.co/