Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Resource capacity tracking for time card reporting

Hello everyone,


I have a visual that I am stuck on creating


I have some requirements that look like this:

- Provide a stacked bar chart that tracks our team's "capacity %" over time

- Provide the data by Month

- Any month that is at or below 100% capacity make a green bar

- If a month is between 100% - 110% make the range for this yellow

- Make the range for any bar with over 110% capacity red

- Bonus requirement, if I can make the most recent time frame a darker shade of Green by using some dax in the conditional formatting.

- Add a red constant line (I know how to do this piece)


Here is a visual I mocked up in Excel to give you an idea of what I am going for:

capacity percent by timeframe.png


I have a table called 'Worklogs' that looks like this:

Time Entry DateTeam MemberTime Entry Logged TimeTask #% Time Spent on Task / Day
5/2/2022Zach Osborn8ABC100%
4/29/2022Jim Brothers2RTK25%
4/22/2022Jeffrey Toole4DEF50%
4/22/2022John Gordon2DEF25%
3/20/2022Lex Luther8GHI100%


Currently I am stuck on adding the column to correctly calculate the resource capacity. I added a column that would divide each line's "Time Entry Logged Time" by 8 to give me a % by day (see "Time Spent on Task / Day" column above), but I know doing it this way is not correct since the order of operations would be off to provide the correct number.


The formula to accuratly show resource capacity would be something like this; Sum Total of Time Entry Logged Time/(# of workdays in a month * 😎


Also, I am not sure how to deal with adding the 2 extra colors as a % of the total.


Here is what my current visual looks like:

example visual. png.png


Thank you!

Community Support
Community Support

Hi @NB689 ,


Unfortunately, a single bar cannot be colored in sections. 

Try using some custom visual, I did some tests and can only set a target line, hope this helps you.



Best Regards,

Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

Super User
Super User

Please show a mockup of your expected result based on your provided sample data. 

Helpful resources

Vote for T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!