Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Expert
i have a qvf wiht a kpi object that compare this month vs last year same month
i put color but i want to put colors depends on the values
example
if the current month is better than the same month last year, paint in green, if not paint in red
how we manage the colors dinamic?
thank you a lot
Fernando
attached de qvf
Hi,
PFA.. Hope this helps.
Thanks,
Vignesh
Within the properties of the measure there is a switch to enable "Conditional Colours". You will need to switch this on and then you will see an "add limit" button. Clicking that will give you an option to set a limit with different colour options, the limit can be determined by an expression. In your case you could simply set the colours to be green on one side and red on the other and the expression being a simple subtraction between the current month expression and the 12 month ago expression.
Rod
Thank you Vignesh