Thanks a lot - that really helped me! Potential feedback you might want to consider: Adding a link to a document that contains the DAX, so people can copy paste the code and are even faster in implementing it in the measure field. Great job!!!!
@devagunalan1056
9 ай бұрын
Brilliant. But the versions have changed since this video and it made it a little harder to follow
@surbhikshah2423
Ай бұрын
hi can you show what exactly was in calendar table? I understand its connecting to using start date in project table but needed to know which columns are there
@user-gx2vt7um6y
Ай бұрын
Thanks a lot for this template I have issue -- if apply data with time as start, end, duration field use show in column in matrix not work!! , you can advice it?
@ahmedkhalid2941
Жыл бұрын
Informative video. I have done the same steps but it says too many values in date value. And I have to visualise all dates. Any advice would be much appreciated
@mategombas771
2 жыл бұрын
Hi there, very nice solution. My only complaint is when you want to use year or month in the column instead of days it falls apart. Simply ignoring starting and ending period or starting and ending year respectively thus resulting null instead of 1.
@stoutis_tavern4203
Жыл бұрын
I tested this with both months and years and if you have working time logic this is no problem. I needed this with months in fact :) Perhaps you try again ;)
@PeterRichards-jy6np
Жыл бұрын
@@stoutis_tavern4203 Hi, I also need to create one where the column is divided by month and not days instead. Can you tell me what part in the DAX that needs to be tweaked in order to get that month column instead?
@stoutis_tavern4203
Жыл бұрын
@@PeterRichards-jy6np Hey, I would add a new column and extract the month from the time table or the respective column(s) with month()
@amolupale2240
Жыл бұрын
This is great! QC is there a way to add data label to the columns (like the date on the bar)
@LNguyen-tx7se
5 ай бұрын
Great video, question: is there a way to remove the status from the matrix row but have a single line based on project that displays both all status within the calendar year? and also sort it based on starting date by project?
@patricioolivares5152
11 ай бұрын
Hi Fernan! Thanks a lot for the helpful video. This is a nice workaround to avoid custom visuals. Is there any chance that you can go one step further and teach us how to create a Gantt Chart using SVG objects in a measure and the matrix visual? I saw a snapshot of a table that includes baseline and current dates. Any advise will be much appreciated!
@juansandoval4895
6 ай бұрын
Thank you for this demo. I had a question regarding an issue I'm having with it though. On the measure it seems to be only pulling either the min or max status, not the inbetween. Have you had issues with this before ? or do you have any idea what it could be?
@benhayes1417
7 ай бұрын
Excellent Video. Easy to follow, thanks
@muzinkuhlu2592
Жыл бұрын
You a rock star 💫 🎉. However, when collapsing to Months the Period is not accurate
@harriewaasdorp4211
2 жыл бұрын
The Collumn Values DAX formula gives me a 1 for the start en finish date, but for the values in between it creates a blank row on the top and puts a 1 there. Any solution to this?
@Adhbuthaha-ASR
6 ай бұрын
Can you able to develop the same with out adding the multiple rows but only one row which can be the current complete month day 1 to day max data.
@devagunalan1056
9 ай бұрын
Thank you very much for this demo.
@ajayvariya4488
7 ай бұрын
If the project duration is just one day, It's not populating over the gantt chart. Could you please advise here....
@SteffenTHughes
3 ай бұрын
i don't follow the logic in the return. i can't get 1's to show up. as in, all of my start dates are Greater than the min calendar date, so i am confused on how your earliest calendar date is GREATER than your start dates, and how the same with the end date. what kind of calendar do you have where your latest calendar date is less than your end date??
@redrum4486
2 жыл бұрын
This is amazing! thanks! I have used this for resource tracking and i have replaced your 'Project' Column with 'Name' and your 'Task' Column with 'Projects so that I can see Names and the days where people are working on Projects. I have also replaced your 'Status column with 'Utilization count. Would i then be able to add a new column for each name that aggregates the Utilization count for days where there is overlap of start and finish dates on the projects they are working on ? And IF the Utilization count is more than 1 for the days with overlaps then I would be able to condition format
@evandunn351
11 ай бұрын
This is extremely helpful Fernan, thank you!
@nghuwei
2 жыл бұрын
Great content and thanks for sharing this tips. Been very useful for project management dashboard. Just one question, any idea if we can show all the task in same row but with different color? Assuming we have a standard set of tasks.
@SolutionsAbroad
2 жыл бұрын
Hi there, yes but you'll need to tweak the SWITCH statement on 10:12 in order to switch up the colours, since this is the only way you can control the,
@asharma2002
2 жыл бұрын
Great video, thanks for sharing this. Can we also have Milestones on this report.
@ingoziman
5 ай бұрын
Thank you for sharing, works great
@stoutis_tavern4203
Жыл бұрын
Hi, really nice solution, worked perfect for me, thank you very much! Best regards
@jacobfrane6221
2 жыл бұрын
I really liked this method! Great tutorial. I’m looking for a solution to show project tasks on the same line. What do you think? To be clear each project would make up the lines of the gantt and multiple task show per project on a signal line over time. I do not have take that overlap, they are repeating tasks.
@SolutionsAbroad
2 жыл бұрын
Hi there, not sure how this will work to be honest, since the gantt chart is just an "illusion" and we're simply just using the Matrix to visualise it
@pallavik707
Жыл бұрын
my date field in column is shwing up only if I check on show items with no data. Moreover, it is showing all the dates from Jan 1 2022, instead of just showing up the start dates. Despite of me joining the date and start date field. Help is appreciated!
@adrianad.5269
3 ай бұрын
Hi, i need move today line and change color bars
@xavierfrancisalmeida8244
Жыл бұрын
Hi, that is an amazing video, used it to create my Gantt chart. I’m trying to get the column totals of the 1’s but just can’t seem to get it. Any ideas how it can be achieved?
@SolutionsAbroad
Жыл бұрын
Hi Xavier, if you're looking to just get a total, you will probably need to convert this into a calculated column, because as measures it doesnt have any row context when you put it by itself
@shamf6624
2 жыл бұрын
Very useful. Thankyou 😊
@SolutionsAbroad
2 жыл бұрын
You're welcome, thanks for watching!
@user-zi7uv5jn8s
Жыл бұрын
How can I do, if I want to visualize just start date?
@thangnguyenhuu556
Жыл бұрын
❤ great, will try tomorroe
@lorenlim2315
2 жыл бұрын
hi! My start and end date consist of years. when i put "date" / "year month" in columns, it's not showing everything. Any help is appreciated. Thanks!
@ahmedkhalid2941
Жыл бұрын
Go to column field and check on show items with no data. It works for me
@Lixia123
2 жыл бұрын
nice trick !
@SolutionsAbroad
2 жыл бұрын
Thanks!
@tlekkabylaimangaliyev3549
Жыл бұрын
Excellent 🎉
@lincolnteo2375
2 жыл бұрын
Hi Fernan, Thanks for the tips....is it possible to size the bar thinner? also, how to contact you via email?
@josefranciscog.6046
6 ай бұрын
Alguien puede compartir los recursos.??
@stefanbonney5145
2 жыл бұрын
I cant get the date field to show as a column.. help would be appreciated
@SolutionsAbroad
2 жыл бұрын
Hey Stefan, have you formatted your data like in the video? Make sure you're dropping the date in the Columns well in your Matrix
@originalmusician1098
2 жыл бұрын
Adding a solution for anyone else who comes by and has this problem. Click on the down arrow of the "Date" field in the columns well. Check "Show items with no data."
@originalmusician1098
2 жыл бұрын
If checking show items with no data causes all the date columns to appear in your matrix, you probably have an issue with the date field in your data table, an issue with the date field in your date table, or the relationship between the two is off.
@originalmusician1098
2 жыл бұрын
One last remark. The data will not be displayed if the dates don't line up in your join. So test your logic and resulting values if you can't get the column values to show up.
@prolf2024
2 жыл бұрын
Awesome, very usefull
@SteffenTHughes
3 ай бұрын
nevermind, it works if you don't have too much data. that was my issue
Пікірлер: 52