Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
141 | |
107 | |
100 | |
82 | |
74 |