Compare two years sales and color code the difference

[vkomarag]

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

[Phil_Seamark · Accepted solution]

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.

https://blog.crossjoin.co.uk/2017/04/11/the-dax-unichar-function-and-how-to-use-it-in-measures-for-d...

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.

[vkomarag]

The link you have provided is really helpful and great.

I have achieved the requirement using image url's. Thank you so much .