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...
amitchandak
Super User
Super UserKelz , I think 1st and 3rd condition has a problem. Reconsider and correct. Alos you should number at all place, you are using percent in first one
KelzAdvocate I
Advocate IHi amitchandak
Thanks for the suggestion, I tried it, but when changing it to a number it comes up as a red box
and that color formatting works in my old model
Cheers,
Kelz