dial guage

So how do the red, yellow and green sections work? if we take the red section for instance it will go from minimum value up to where? would it always be hospital or always provider? I ask as this will determin if the dial guage will work. If they are not linear in values then you will get wierd orange green red progressions etc. If the provider say, always has a lower score than the hospital then it would become your next section (orange) and then the hospital (green).

If it just wont work, then you can always make a dial guage in excel with exactly the pointers etc you need and with a bit of if-muckery and pie action you can have the sections etc become dynamic. Then with Powerbi excel addin you can serve the guage up on the dashboard. Not perfect as its not dynamic with the rest of teh dashboard but it is in one place.