Forum Discussion
Gantt Chart with different stages
- 6 years ago
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
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
Please open access to the pbix link cause currently the link cannot be accessed, thanks😊