Hi Sam Hall, Glad you find the video helpful. We are so grateful to have had such positive feedback.

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: kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA

Thanks for the suggestion, Steve!

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

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: kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA

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.

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.

Hi Vinod, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!

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 KZfaq 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/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

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 KZfaq 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/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

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

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!

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 KZfaq channel pertaining to this topic. kzfaq.info/get/bejne/fq5kY6qiqLCWpZs.html kzfaq.info/get/bejne/fdileZeb2rmmXas.html blog.enterprisedna.co/power-bi-page-navigation-updates-tutorial-review/ kzfaq.info/get/bejne/e99hi5CpmaqrYIU.html kzfaq.info/get/bejne/odCRjdeK0NvGmnU.html kzfaq.info/get/bejne/bsiggbNzmbm0g5s.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 KZfaq 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/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

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!

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.

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

Hi Krish, you can check out the tutorial we have on creating a date table here: kzfaq.info/get/bejne/hKeXm8R3rL66dnk.html

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/

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 KZfaq 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/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

Chocho, where you able to find a solution for the real date?

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/

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/

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 KZfaq 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/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

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 KZfaq channel so that you don't miss out on any updates pertaining to the Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA

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/

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 KZfaq 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/ kzfaq.info www.linkedin.com/groups/12004506/

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 KZfaq 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/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

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/

Hi Lori, find all forum posts on setting up data slicer here: forum.enterprisedna.co/search?q=set%20up%20data%20slicer

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 KZfaq 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/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

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 KZfaq 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/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

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. kzfaq.info/get/bejne/i7iEdJp7v9mlpKs.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

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

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/