Timesheet

[Anonymous]

Hello,

I want to create a timesheet template in pbi.

I have a list of employees down the left side and need the columns to be days of the week (Sunday-Saturday) how can this be done

[v-lid-msft]

Hi @Anonymous ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft]

Hi @Anonymous ,

We can create a calculated column "WeekDayNumber in your calenday table:

WeekDayNumber = WEEKNUM([Date])

Then we can create a calculated table and cretae connection between two "WeekDayNumber" column as the column field of matrix visual

Column Header Table =
DATATABLE (
    "WeekDayNumber", INTEGER,
    "WeekDayName", STRING,
    {
        { 1, "Sunday" },
        { 2, "Monday" },
        { 3, "Tuesday" },
        { 4, "Wednesday" },
        { 5, "Thursday" },
        { 6, "Friday" },
        { 7, "Saturday" }
    }
)

If it doesn't meet your requirement, kindly share your sample data and expected result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

Best regards,

[amitchandak]

Use Matix visual

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

Prefer creating a day calendar and have weekdaysAppreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin there.

[vivran22]

Hello @Anonymous 

Can you please demonstrate with some example or an Excel based template?

Regards,

Vivek