Forum Discussion
Help: Traffic Light Staff Capacity formula
Hi, Kelz
According to your description and sample pictures, I can roughly understand your requirement, I think you can try to create a measure to define the data color manually instead set it in the color formatting, you can try this measure:
Color =
SWITCH(
TRUE(),
[Free Time]<-10,"Red",
[Free Time]>=-9&&[Free Time]<1,"Yellow",
[Free Time]>1&&[Free Time]<=1000,"Green")Then go to the data color setting of this column chart, set like this:
And you can get what you want, like this:
You can download my test pbix file below
Thank you very much!
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.
Hi,
Thanks for that, it didnt work, but i think it might be because I need to link it to the indivdual/unique staff members.
ie bob is 37.5, sally is 20 hours, jane is 30 hours which is under the employee tab.
do you know how I can get the free time formula to filter on each of the staff members capacity and not the whole group?
thanks
kelz
Hi,
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.
Hi,
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 🙂