Is it possible to Color a KPI value?
Hi,
I have some troubles getting the Color agents to work on an KPI object. It works in 'Show data' form, but not when you showcase it in 'chart'
I want to color the KPI in green or red depending on whether or not it is positive numbers. It looks like it is coloring the value properly in the data
But when I want to showcase it in KPI format it does not include the color agent, and return to the theme text color
Is it possible to use the color agents on KPI's and if so, how would you do it?
0
Comments
Hi Christoffer,
Two things need to be done.
Hej Ole,
Tak for svar. Det hjælper på min test, men jeg støder på udfordringer når det er en calculation jeg skal vise.
Jeg har lavet en Lookup value på en row calculation.
På denne virker det til at virke ved dataen.
Ved dog ikke helt hvordor den ene viser gul. Men det beregningen i bunden for Qty Inventrans jeg forsøger vise som KPI og i det tilfælde viser den stadig tema farven.
Hvad gør jeg forkert her?
Hi Christoffer
It is a bit odd, but when you use the lookup value function, that reference doesn't really have a link to your row calculation.
Your look-up just points to your original measure, but in a special row...
To fix it, you could add a visibility agent that hides all your original rows and just leaves the row calculation.
Now the color agent will have an effect because all other data is hidden (again a little strange to understand).
Hope it works for you :-)
br/Niels
Please sign in to leave a comment.