Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Hi @sparkplug9375 ,
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,
Hi @sparkplug9375 ,
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,
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.
Hello @sparkplug9375
Can you please demonstrate with some example or an Excel based template?
Regards,
Vivek
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |