Forum Discussion
Colour saturation help
- 10 years ago
Hi Herbert,
I´ve been trying with the option of color saturation of some visualization (diverging option), but it does not satisfy my expectations, so when I saw your answer to this matter, decided i need to try it your way.
My report acctually has 5 different fields/tables (Leading, Managing, Onboarding, PAC, Whitebelt) each one for a specific thema.
In each Table i created a measure named KPI. For each KPI i have a specific target. Would like to give them a conditional color using your formula. If target is reach should be green, if -10% below of the target yellow, if its even lower red.
So i figured out i need to create a new table with each KPI name and the target.
KPI's Target Color
Leading 90%
Managing 90%
Onboarding 100%
PAC 90%
Whitebelt 90%
My question is, how I should write your color formula, if each KPI comes from a measure of a different table. Should be something like this? How should I do the part of -10% of target = Yellow, -20% or less of target= red???
Color = IF ( NewTable[KPI´s] >= TableLeading[LeadingKPI]
TableManaging[ManagingKPI]
TableOnboarding[OnboardingKPI]
TablePAC[PACKPI]
TableWhitebelt[WhitebeltKPI],
¨Green¨, ¨Yellow¨, ¨Red¨)
Would appreciate your input on this.
Thanks!