Concatenate Arrow Object with Expression value

[ZoeM]

Hello community.

I have a pivot chart with one dimension and several expressions. My dimension is year and I am using it as a column to compare years across the different expressions. 

The user would like to compare the years (more than one) and have arrows go either up or down depending on the value.

I would like the arrows to start when more than one year is selected and starts with the year in the second column.

Here is a mock up of intended end result in excel:

I have attached a sample dashboard with a simple pivot chart and one expression to hopefully see if it can work.

Thanks guys.

[sunny_talwar · Accepted solution]

Try this

If(ColumnNo() = 1, Sum([#of Days to Purchase]),
If(Sum([#of Days to Purchase]) < Before(Sum([#of Days to Purchase])), Sum([#of Days to Purchase])&chr(8595), Sum([#of Days to Purchase])&chr(8593)))

[ZoeM]

Always awesome Sunny.

Can I take this one step further? Is it possible to have just the arrows be a specific color based on value? So if it is an increase then it is good and we want it to be green? 

How would I define that expression?