Forum Discussion
Helper IIICompare two years sales and color code the difference
Hi All,
I have a requirement where i have to compare 8 categories current years and previous years measures and notify the difference with arrow symbol whether there is a decrease/increase w.r.t previous years measure. Also, if there is increase and the increase is more than 5% then we have to represent the arrow otherwise no need to show the arrow.
Is there any better way of representing this scenario.
Currently I am doing it in Matrix by just representing the values and conditional formatting. Looking for a better approach
Thanks
KVB
Hi vkomarag
In terms of adding arrows to your matrix, the UNICHAR function allows you to cheaply add icons. Please read this blog for some ideas on that front.
As per your measures, do you also need help with them? It should be pretty straight forward to create a mesure for this/last year and then a difference delta/percent measure if required. Perhaps if you post some sample data we can give you some ideas.
2 Replies
- Phil_Seamark
Microsoft Employee
Hi vkomarag
In terms of adding arrows to your matrix, the UNICHAR function allows you to cheaply add icons. Please read this blog for some ideas on that front.
As per your measures, do you also need help with them? It should be pretty straight forward to create a mesure for this/last year and then a difference delta/percent measure if required. Perhaps if you post some sample data we can give you some ideas.
vkomaragThe link you have provided is really helpful and great.
I have achieved the requirement using image url's. Thank you so much .