Trend - instead of line use up or down arrow

[Anonymous]

Hello, possible to use use up or down arrow in place of trend line?

[parry2k]

@Anonymous you mean in line chart you want to show arrows instead of line?

[Anonymous]

Sorry no....just an arrow...so users select time period...is the trend for the time period for a particular metric up or down? 

[parry2k]

@Anonymous hope this post help, also in conditional formatting there is a icon set, here is the link to this

[Anonymous]

Hi @parry2k thanks for this. I've read the info in the link and it appears to show up/down based on how the latest data compares to last year.

Under analytics we can chose to show a trend line for a time series.

This trend line applies to the date range selected, not to eg previous year as I understand .

Is it possible to replace that with a simple arrow to denote whther the trend is up or down for the time period selected?

Eg user selects spend for 01/01/2020 to 20/02/2020 and the spend "trend" is "up"

Many thanks

[v-yuta-msft · Accepted solution]

@Anonymous ,

You can use table visual and dax function UNICHAR() to achieve this. For more details, I would suggest you refer to the tutorial below:

https://www.youtube.com/watch?v=cboA5AtAPeg

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Caz_16]

So try this:

In the IF statement you saw in the link of the previous post, use the ALLSELECTED function inside of the IF statement. That way it will only evaluate the IF statement on the data that you want. ALLSELECTED works on the data affected by page filters. Apply filters to the page by dragging variables into the FILTER PANE on the right side of the desktop app.

I think this will get you to where you need to be, or at least POINTS you in the right direction (arrow pun). 

[parry2k]

@Anonymous can you share sample pbix with exepcted output and will get you the solution.