Forum Discussion
Calendar view for multiple tasks across multiple projects
Hi all
I'm looking to create a calendar view for multiple milestone across multiple projects - as per the below table. I can create a calendar to show all of milestone 1 across projects but can't see how I can also show mistone 2 and 3 in teh same calendar. Ideally these would need to be colour coordinating so it is clear which milestone the calendar entry is referring to.
Any ideas on how I could represent this data? The team I am building it for, we havea weekly meeting and need to see which of the below milestone are falling within the coming 2 weeks.
| Milestone 1 | Milestone 2 | Milestone 3 | |
| Project 1 | Date | Date | Date |
| Project 2 | Date | Date | Date |
| Project 3 | Date | Date | Date |
| Project 4 | Date | Date | Date |
| Project 5 | Date | Date | Date |
| Project 6 | Date | Date | Date |
| Project 7 | Date | Date | Date |
2 Replies
Anonymous , one way is to unpivot and use them
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/You will have milestone and date as column
