Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
CraigSchulz
Helper II
Helper II

Create New Table of Budgeted Hours with Dates Attached

I have a table (part shown below) that provides budgeted labor hours by account by day of week. Budgeted hours for a given day of week for a given account will not vary by actual date. However, I want to create a visual that shows, for any one account determined by a slicer, 28 consecutive dates on the X-axis, Monday - Sunday for 4 weeks, and shows actual labor hours worked on those dates for the selected account compared to the budgeted hours for that account and day of week. Can anyone give me an idea on how to do this? As a clarification, the budgeted labor hours portion of the visual would repeat the same set of 7 values (one for each day of the week) 4 times, a four week analysis.

- Craig

Budget Table.PNG

1 REPLY 1
v-yuta-msft
Community Support
Community Support

Hi CraigSchulz,

 

"I want to create a visual that shows, for any one account determined by a slicer, 28 consecutive dates on the X-axis, Monday - Sunday for 4 weeks, and shows actual labor hours worked on those dates for the selected account compared to the budgeted hours for that account and day of week. "

 

<--- Could you clarify more details about the logic of comparasion and show some sample of your expected results?

 

Regards,

Jimmy Tao

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.