Forum Discussion

Batfab's avatar
Batfab
New Member
5 months ago
Solved

create a report with calender

hi,

I would like to import an Excel list with names in rows and events in columns.
I may have the same name appear in multiple rows—for example, an absence from January 2 to January 5 in one row, and the same name in another row with an absence on April 15.
My Power BI report needs to display the data by employee, so I want one row per name in a columnar calendar showing all events for the year.

could you please help me to create this report

Tips and Tricks
  • Sergii24's avatar
    Sergii24
    5 months ago

    H Batfab, here it is. Make sure to prepare your data in the same format where you have all dates you need repeated for each employee and absence tracked in a separate column. Then use matrix to create an Excel similar PivotTable. Good luck with your project!

4 Replies

  • Sergii24's avatar
    Sergii24
    Icon for Super User rankSuper User
    5 months ago

    H Batfab, here it is. Make sure to prepare your data in the same format where you have all dates you need repeated for each employee and absence tracked in a separate column. Then use matrix to create an Excel similar PivotTable. Good luck with your project!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 months ago

    Hi,

    Please share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

  • v-prasare's avatar
    v-prasare
    Icon for Community Support rankCommunity Support
    5 months ago

    Hi Batfab ,

    if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

     

    Ashish_Mathur& Sergii24, Thanks for your prompt response.

     

     

    Thank you for your patience and look forward to hearing from you.
    Best Regards,
    Prashanth Are
    MS Fabric community support

  • v-prasare's avatar
    v-prasare
    Icon for Community Support rankCommunity Support
    4 months ago

    Hi @Batfab ,

    if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

     

     

     

    Thank you for your patience and look forward to hearing from you.
    Best Regards,
    Prashanth Are
    MS Fabric community support