Employee Hours Conditional Formatting Adjustment

[walker8888]

Hi,

I have created a Resource Capacity report and I am having issues having the 40 hour week capacity adjust as it pertains to going by weeks, months and years. How can I get that to update automatically and show when resources are out of compliant or not. I currently have the first rule as If value > than 40 number and < 500 then red, unless blue. This work for showing the capacity for the week, but how can I do it when it get's to two weeks, three weeks, a month a year etc. Any help would be greatly appreciated. 

[v-nmadadi-msft]

Hi @walker8888 ,

Can you please confirm whether you have resolved issue. If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. This will be helpful for other community members who have similar problems to solve it faster. 

If we don’t hear back, we’ll go ahead and close this thread.Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you

[v-nmadadi-msft]

Hi @walker8888 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-nmadadi-msft]

Hi @walker8888,

May I ask if you have resolved this issue? If so, please let us know how and accept it as the solution otherwise please consider sharing sample data so we could try to get the expected output. 

Thank you.

[walker8888]

Actual Timestamps

[lbendlin · Accepted solution]

Are the shifts crossing day boundaries?  What is the level of detail of the timestamps (minute level, or hour level, for example?)

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[walker8888]

Woud an excel file suffice?

[lbendlin]

yes but you would need to place it onto a public file share.  you cannot attach it here if you are not a super user.

[lbendlin]

How are these hours recorded?  a default 8 hrs per work day?  Or with actual timestamps?