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
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
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 :).