Add red/green arrows in table column based on whether value has changed since last year.

[andytmcc]

I currently have a 2 column table on my page. First column gives the name of 18 geographical areas and the second column gives a numerical value for each area. The page has an overall year filter so the user can select one of multiple years.

Is it possible to add a column to the table that shows a red down or green up arrow based on whether the numerical value is higher or lower that the previous years data. E.g if the page year filter is set to 2019/2020 can arrows appear that compare that years data to 2018/2019 or if user selects 2016/2017 can the arrows compare the figures to 2015/2016. Maybe I'm getting ahead of myself - is it even possible to add green/red arrows at all into a table? If not, what would be the best alternative to showing something like this? Thanks

[v-henryk-mstf]

Hi @andytmcc ,

Thanks for your solution.  If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry

[andytmcc · Accepted solution]

Hi Henry, sorry for slow response. I came upon a solution by creating a calculate column that brings in the previous years value for each row. I then created a second calculated column that assigned a value 0, 1 or 2 dependent on the difference between this years and previous years values. These numbers (0,1,2) were then used for conditional formatting.

[v-henryk-mstf]

Hi @andytmcc ,

It doesn't sound like it would be hard to implement, for the year filter you are talking about is it a separate table (similar to a date table) and are relationships established between the tables.

Please provide test data and a screenshot of the desired result so that I can answer you as soon as possible.

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Best Regards,
Henry