Forum Discussion
Kelz
Advocate I
Advocate IHelp: Traffic Light Staff Capacity formula
Hi, I am trying to re-create a formula from one Power Bi report (built with Excel spreadsheets) into a new Power Bi (bulit with API's into the data) to show conditonal formatting in colour on a c...
v-robertq-msft
Community Support
Community SupportHi,
According to your description, I can roughly understand what you want to get. But I find it hard to create the test data based on your requirement details. Would you like to post some sample data in table form or pbix file(without sensitive data) and your expected result(like the chart you want to get and the correct measure value based on your sample data)?
Thanks very much!
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
KelzAdvocate I
Advocate IHi,
Here is the table examples
Timesheet data
| Date | hours | Employee | Project |
| 1/10/2021 | 4 | Bob | Project 1 |
| 1/10/2021 | 2 | Sally | Project 3 |
| 1/10/2021 | 4.5 | Jo | Project 5 |
| 1/10/2021 | 5 | Randy | Project 1 |
| 1/10/2021 | 3.75 | Sandy | Project 3 |
| 1/10/2021 | 3 | Tina | Project 5 |
| 1/10/2021 | 4 | Tim | Project 1 |
| 1/10/2021 | 4 | Roger | Project 3 |
| 1/10/2021 | 4 | Bob | Project 1 |
| 1/10/2021 | 2 | Sally | Project 3 |
| 1/10/2021 | 4.5 | Jo | Project 5 |
| 1/10/2021 | 5 | Randy | Project 1 |
| 1/10/2021 | 3.75 | Sandy | Project 3 |
| 1/10/2021 | 3 | Tina | Project 5 |
| 1/10/2021 | 4 | Tim | Project 1 |
| 1/10/2021 | 4 | Roger | Project 3 |
| 4/10/2021 | 4 | Bob | Project 1 |
| 4/10/2021 | 2 | Sally | Project 3 |
| 4/10/2021 | 4.5 | Jo | Project 5 |
| 4/10/2021 | 5 | Randy | Project 1 |
| 4/10/2021 | 3.75 | Sandy | Project 3 |
| 4/10/2021 | 3 | Tina | Project 5 |
| 4/10/2021 | 4 | Tim | Project 1 |
| 4/10/2021 | 4 | Roger | Project 3 |
staff table:
| Employee | Capacity |
| Bob | 40 |
| Sally | 20 |
| Jo | 45 |
| Randy | 50 |
| Sandy | 37.5 |
| Tina | 30 |
| Tim | 40 |
| Roger | 40 |
Thanks 🙂