Forum Discussion
How to make progress arrows
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?
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/811692example
/////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
4 Replies
Anonymous , Just saw you already updated before my update. There are a few more options to explore, I have given links for that.
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/811692example
/////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