Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
I want to have my KPI fonts color conditioned, with the fonts color in blue when the number is higher than zero, and turn red when the results is below zero. having tried to build master measure with conditional color with limit in zero, but it doesn't work out changing the fonts color automatically. does anyone can help with this?? thanks!
Hi,
I think you are looking for change in colour based on year over year sales, which can be achieved using Extension named "Climber KPI", you can use directly it by adding two measures which you want to compare or you can add formula in the Appearance/colour/text expression as:-
=If(Sum({<[Order Date.autoCalendar.Year]={"$(=Year(Max([Order Date])))"}>}Sales) > Sum({<[Order Date.autoCalendar.Year]={"$(=Year(Max([Order Date]))-1)"}>}Sales),Green(),Red())
Please find attached file for Climber KPI.
Thanks
Tushar
Hi,
You can set the limit for this.
goto: - KPI properties/ Appearance/ Colour/ Add limit
Change as per your requirement.
Thanks:-
Tushar
Hi,
As per my understanding you have requirement like if suppose taking kpi with measure as sale, so if sale is greater than 0 it will be in blue and for less than 0 it will be red, .. right??
Thanks
Tushar
Hi,
I think you are looking for change in colour based on year over year sales, which can be achieved using Extension named "Climber KPI", you can use directly it by adding two measures which you want to compare or you can add formula in the Appearance/colour/text expression as:-
=If(Sum({<[Order Date.autoCalendar.Year]={"$(=Year(Max([Order Date])))"}>}Sales) > Sum({<[Order Date.autoCalendar.Year]={"$(=Year(Max([Order Date]))-1)"}>}Sales),Green(),Red())
Please find attached file for Climber KPI.
Thanks
Tushar