How to make progress arrows

[Anonymous]

Hi, I have a question, does power bi allow you to make progress arrows?

Here I have an example of conditional formatting, if something is greater than 0 it is green, and if it is less than it is red.

Is it possible to illustrate it more with e.g. progress arrows and add them next to values?

[amitchandak · Accepted solution]

@Anonymous , You have icon formatting options 

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/

You can also have icon measure with color measure, use measure in conditional formatting use field value option
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

example

/////Arrow
Arrow =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, UNICHAR(9650),
_change = 0, UNICHAR(9654),
_change < 0, UNICHAR(9660)
)

/////Arrow Color
Arrow color =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, "green",
_change = 0, "blue",
_change < 0, "red"
)

UNICHAR - Tool for Custom Icon Formatting: https://www.youtube.com/watch?v=veCtfP8IhbI&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=50

[Anonymous]

I did not notice that there is an option to add icons in conditional formatting, you can find arrows there, solution found.

[amitchandak]

@Anonymous , Just saw you already updated before my update. There are a few more options to explore, I have given links for that.

[Anonymous]

Thank You 🙂