*****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...
@sambolade8280
5 жыл бұрын
Very great idea. Have you got the Pbix file? as not all the steps were shown in the video
@aduck24
3 жыл бұрын
This is amazing I must say. You just gave me some ideas to work on my next report. Thank you for the great content.
@EnterpriseDNA
3 жыл бұрын
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: kzitem.info/rock/y2rBgj4M1tzK-urTZ28zcA
@SteveDPIves
Жыл бұрын
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.
@EnterpriseDNA
Жыл бұрын
Thanks for the suggestion, Steve!
@NotYourAverageJoeRogan
4 жыл бұрын
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.
@champagnechampionking2178
3 жыл бұрын
I am definitely interested in how you went about doing this.
@champagnechampionking2178
3 жыл бұрын
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
@samhall100
2 жыл бұрын
I'm going to use this method fow showing when staff are taking vacation in the visual
@EnterpriseDNA
2 жыл бұрын
Hi Sam Hall, Glad you find the video helpful. We are so grateful to have had such positive feedback.
@TheloniousWoW
5 жыл бұрын
I really like these non-finance reports youre creating videos on! Keep it up! :)
@kevinharilal8288
3 жыл бұрын
This is sooooo cool. Innovating through power BI. Well done mate.
@EnterpriseDNA
3 жыл бұрын
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: kzitem.info/rock/y2rBgj4M1tzK-urTZ28zcA
@vinodtpba
3 жыл бұрын
Thank you.
@EnterpriseDNA
2 жыл бұрын
Hi Vinod, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!
@Gergoo1991
5 жыл бұрын
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.
@roberthalexei1641
2 жыл бұрын
Perfecto!!!
@EnterpriseDNA
2 жыл бұрын
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!
@jyotidatta2126
2 жыл бұрын
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?
@EnterpriseDNA
2 жыл бұрын
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 KZitem channel pertaining to this topic. kzitem.info/news/bejne/qX5qlnunfHxjqJw kzitem.info/news/bejne/qKirrGigroVzYKw blog.enterprisedna.co/power-bi-page-navigation-updates-tutorial-review/ kzitem.info/news/bejne/pq9nvmGubXZ4Y4Y kzitem.info/news/bejne/zKCXwKiPpKeTnXY kzitem.info/news/bejne/mZimtIR4bYWBhpw 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 KZitem 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/ kzitem.info/rock/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/
@matthewgorham2756
2 жыл бұрын
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.
@EnterpriseDNA
2 жыл бұрын
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 KZitem 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/ kzitem.info/rock/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/
@franzyz1978
5 ай бұрын
Impressive. Would like to know jhow you enable the conditional formatting for those different task types.
@UltrashockChannel
5 жыл бұрын
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?
@UltrashockChannel
5 жыл бұрын
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
@marounsader318
5 жыл бұрын
@@UltrashockChannel what was the formula [selected day] you used?
@UltrashockChannel
5 жыл бұрын
@@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
@brandyharding7692
4 жыл бұрын
@@UltrashockChannel Awesome!
@davidmunoz2347
3 жыл бұрын
@@UltrashockChannel This needs more appreciation, very helpful, thank you. I you ever are close to Grapevine TX let me invite you a beer.
@andreadellaquila3622
2 жыл бұрын
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])
@EnterpriseDNA
Жыл бұрын
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 KZitem 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/ kzitem.info/rock/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/
@FeliPimp1990
3 жыл бұрын
Hello, What do you mean with VALUE([Selected Date]) dax show me an error
@EnterpriseDNA
3 жыл бұрын
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
@ikhoorwatjezegtmaarikluisterni
4 жыл бұрын
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.
@NotYourAverageJoeRogan
4 жыл бұрын
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....
@ivanalducin2143
4 жыл бұрын
You dont explained how to create [Selected Dated] measure :(
@EnterpriseDNA
4 жыл бұрын
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.
@eugena4675
4 жыл бұрын
@@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] ) "
@jonprendergast7009
2 жыл бұрын
@@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.
@gerardoespinosa2453
Жыл бұрын
How do you get "Selected Date"? Isn't a field in your date
@EnterpriseDNA
Жыл бұрын
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 KZitem 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/ kzitem.info/rock/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/
@andywithers592
Ай бұрын
@@EnterpriseDNAMany thanks for explaining where the Selected Date came from. Great tutorial, but i just a table full of zeros! I still see this a win though 😊. An hour ago, I had no clue on how a Gantt could be built from a Matrix. Thanks again.
@adrianjliu
2 жыл бұрын
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.
@EnterpriseDNA
2 жыл бұрын
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!
@adrianjliu
2 жыл бұрын
@@EnterpriseDNA Thank you. I changed it to a weekly chart and it looks great. Thanks for showing the way!
@TamannaKarim
Жыл бұрын
@@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.
@romitagarwal572
Жыл бұрын
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
@UltrashockChannel
5 жыл бұрын
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!
@ikhoorwatjezegtmaarikluisterni
4 жыл бұрын
Chocho, where you able to find a solution for the real date?
@reedybp
4 жыл бұрын
I'm curious, I don't suppose there is a way to overlay text labels on the visual?
@ooblet
Жыл бұрын
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!
@RajatSharma-tn6gf
5 жыл бұрын
Cool
@wissemkhenissi2724
5 жыл бұрын
That's Fantastic!! Is it available to be downloaded in your website ?
@azhaslem6912
5 жыл бұрын
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!
@2007asraff
2 жыл бұрын
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
@EnterpriseDNA
2 жыл бұрын
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/
@sandrojrteclas
3 жыл бұрын
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
@iagofonseca93
2 жыл бұрын
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!
@pbele21
4 жыл бұрын
How about drilling up to months or quarterly? This is awesome by the way!!
@EnterpriseDNA
4 жыл бұрын
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/
@sollapalooza
3 жыл бұрын
Can I create a slicer or some kind to change the start date or duration of each task? or at least the first task?
@EnterpriseDNA
3 жыл бұрын
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 KZitem channel so that you don't miss out on any updates pertaining to the Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ kzitem.info/rock/y2rBgj4M1tzK-urTZ28zcA
@krishanmw1
Жыл бұрын
Can you share creating a table for Dates
@EnterpriseDNA
Жыл бұрын
Hi Krish, you can check out the tutorial we have on creating a date table here: kzitem.info/news/bejne/r3edzpV8gIqHeXo
@WasitaWitchu
2 жыл бұрын
in the 'step 1' you can metric custom measure 'selected date' ? how do you create that
@EnterpriseDNA
2 жыл бұрын
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 KZitem 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/ kzitem.info/rock/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/
@klauswohlfarth9020
2 жыл бұрын
Hi Is thyere a place where one could download the complete template of this Gantt using the Matrix Visual?
@EnterpriseDNA
2 жыл бұрын
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 KZitem 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/ kzitem.info/rock/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/
@Dan-en5hz
2 жыл бұрын
How do you also display the project summary tasks in the Gantt Chart in Power BI?
@EnterpriseDNA
2 жыл бұрын
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 KZitem 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/ kzitem.info/rock/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/
@lorismith6167
4 жыл бұрын
@Enterprise DNA how is the date slicer set up? What field are you using?
@EnterpriseDNA
4 жыл бұрын
Hi Lori, find all forum posts on setting up data slicer here: forum.enterprisedna.co/search?q=set%20up%20data%20slicer
@maminhaj730
3 жыл бұрын
hey, I was curious to know, whether we can link up the activities in a Power BI Gantt Chart?
@EnterpriseDNA
3 жыл бұрын
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/
@Ethan-dd4ln
3 жыл бұрын
Love the video, Just subscribed! Is there a way to export a table to showw the values that are 0 per project?
@EnterpriseDNA
3 жыл бұрын
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/
@WasitaWitchu
2 жыл бұрын
how do you connection project start date and end date to the 'dates' table?
@EnterpriseDNA
2 жыл бұрын
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 KZitem 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/ kzitem.info/rock/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/
@atnewtonify
4 жыл бұрын
Hi I'm having issues with the [Selected Date] Measure on this video - Can anyone suggest resolution?
@EnterpriseDNA
4 жыл бұрын
Hi Alex, can you explain the issue further to help us better understand? Thanks!
@atnewtonify
4 жыл бұрын
@@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
@atnewtonify
4 жыл бұрын
@@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
@ArpitSharma-kk9tl
2 жыл бұрын
Is it possible to further divide it into hours and minutes
@EnterpriseDNA
2 жыл бұрын
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 KZitem 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/ kzitem.info www.linkedin.com/groups/12004506/
@bahman7210
4 жыл бұрын
is there any way to add more fields as tooltip to matrix?!?
@EnterpriseDNA
4 жыл бұрын
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. kzitem.info/news/bejne/toiKp2uAk6Vyp6w 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
@ArtsGalaxy1
2 жыл бұрын
Thanks for great Idea ,If still available, I need your sheet data and Report.
@EnterpriseDNA
2 жыл бұрын
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/
@tahahafiz8552
2 жыл бұрын
Very great idea. Have you got the Pbix file? as not all the steps were shown in the video
@EnterpriseDNA
2 жыл бұрын
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/
Пікірлер: 94