Forum Discussion
Gantt Chart with different stages
Please see this link for the example pbix file on how to do this. Here is an image of the result. Of course, you can adapt the colors, and hide the text if you want (by using same color measure on Text color in conditional formatting as I used for background).
In the pbix, you will see a simple DAX Date table to get the Week Dates for the columns. Note there is no relationship between the two tables. There are also 3 measures - 1 to check if the project is active during that week, 2 to detect which phase/stage it's in, and 3 return a color based on phase/stage. You can get more granular with color codes (I just used "Green", "Blue", etc. to demonstrate). You can also build in some logic based on the Site value to get different color families.
https://drive.google.com/file/d/1UcKquV6A4oTRmonMDx7PKXtUGtmQwzQZ/view?usp=sharing
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
mahoneypat For change in color I am using site and for change in darkness I am using activity. Basically just want to use Site as a legend field, and can be ignored if we are anyways using a matrix for our solution
Microsoft EmployeePlease see this link for the example pbix file on how to do this. Here is an image of the result. Of course, you can adapt the colors, and hide the text if you want (by using same color measure on Text color in conditional formatting as I used for background).
In the pbix, you will see a simple DAX Date table to get the Week Dates for the columns. Note there is no relationship between the two tables. There are also 3 measures - 1 to check if the project is active during that week, 2 to detect which phase/stage it's in, and 3 return a color based on phase/stage. You can get more granular with color codes (I just used "Green", "Blue", etc. to demonstrate). You can also build in some logic based on the Site value to get different color families.
https://drive.google.com/file/d/1UcKquV6A4oTRmonMDx7PKXtUGtmQwzQZ/view?usp=sharing
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
- mahoneypat
Sorry. I made it restricted by mistake. Anyone with link now can access it. Please let me know if not.
Regards,Pat
https://drive.google.com/file/d/1UcKquV6A4oTRmonMDx7PKXtUGtmQwzQZ/view?usp=sharing
- mahoneypat
I don't think we could show a today line in the visual. The most probably would be to override the color of the cells in the current week. You would then not be able to see the phase.
Another idea would be to make a relative week column in the Date table and use that instead of the actual date. That way, it would show as Week -2, Week -1, Week 0, Week 1, Week 2 across the top and week 0 would be the current week.
Regards,
Pat
mahoneypat can you please provide access to the PBIX file. I think this would just work for me
mahoneypat This is cool stuff. This would work for me. Just a couple of more questions, is there any way we could highlight the current week / Today as we usually have in the Gantt Charts. And i see that when a phase changes in the matrix there seems to appear a white line, can we show it in a bit more continuous kind of pattern in the matrix visual?
Hi,
Sorry for hijacking the thread.. Im new to power BI and have similar use case and trying to implement the solution you gave.
I have value "NA" in for dates, but i need to keep this to show there is no plan decided yet for this particular stage.
Im having issue while trying to create the date table because of this.. How do I convert NA as blank field instead ?
Thank you for your help in advance :).
Please open access to the pbix link cause currently the link cannot be accessed, thanks😊
Please open access to the pbix link cause currently the link cannot be accessed, thanks😊
