Forum Discussion

jamesclark458's avatar
jamesclark458
Frequent Visitor
2 years ago
Solved

Project Heatmap

Hi Community,   I am looking for some help but haven't managed to find the right thread on the forum.   I have been asked to create a Heatmap to show how many projects we have in any given Year, ...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

     

    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

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

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

  • jamesclark458's avatar
    jamesclark458
    Frequent Visitor
    2 years ago

    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. 

     

    ProjectStart DateEnd Date
    Project A01/01/202431/01/2024
    Project B10/01/202425/01/2024
    Project C05/01/202420/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

     

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

       

      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

      • jamesclark458's avatar
        jamesclark458
        Frequent Visitor
        2 years ago

        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