Forum Discussion

Kelz's avatar
Kelz
Icon for Advocate I rankAdvocate I
4 years ago

Help: 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...
KNP's avatar
KNP
Icon for Super User rankSuper User
4 years ago

Hi Kelz - Did you mark this as solved? I see it is marked as solved but your latest question came in after the "solution".

 

Kelz's avatar
Kelz
Icon for Advocate I rankAdvocate I
4 years ago

Hi, no I didn't, I think the system may have? or somebody might have if they can do that? and Im unsure how to revert it.

 

The instructions Robert had were great and work well if I wanted to show the free time, but I wanted to show the hours the staff had worked for the month with the colour for each staff member based on whether they were under, over or at their contracted hours for month/s selected (I have a slicer on months and muiltple can be selected). 

 

the original formula worked really well for the model I created using excel reports, but I've had to recreate the report using an API, so the names / tables are slightly different but still has the same information. 

 

Thanks

Kelly

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Kelz , KNP , I have unmarked the "Accepted Solution"  as it looks as Kelz  has not found the correct answer to their question.  If I am wrong, please advise.

     

    Thank you for being part of the community!

     

    cc: v-robertq-msft, Anonymous, chass