Forum Discussion
Project Heatmap
how many projects we have in any given Year, Month and Week.What's your definition of "week" and how does it relate to your definition of "month" ?
see attached
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi lbendlin
Thank you for the tip.
I have put some sample data in the table below. For ease, I have put all the data into a single month.
| Project | Start Date | End Date |
| Project A | 01/01/2024 | 31/01/2024 |
| Project B | 10/01/2024 | 25/01/2024 |
| Project C | 05/01/2024 | 20/01/2024 |
In terms of the expected outcome, I have provided a straightforward view of what I hope to achieve: a calendar view, in this case January 2024, that shows in a heatmap style where we have the lowest and highest number of projects occuring simultaneously.
I hope this provides a bit more clarity to my ask.
Thank you,
Jamie
how many projects we have in any given Year, Month and Week.What's your definition of "week" and how does it relate to your definition of "month" ?
see attached
Hi lbendlin
Thank you so much for sharing this. It has worked a treat.
In terms of the definitions of month, this is purely just the calendar month; Jan, Feb, Mar etc.
For weeks, this is Monday - Sunday, however given the level of detail we have been able to get from the solution you have provided, I think we have the granularity required and users can filter on the dates they need.Thank you again for all your help 🙂
Jamie
yeah, mixing weeks and months is ill advised at best and misleading at worst.