Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Creating cutom icons for conditional formatting

Hi all,   I'm trying to add custom icons to conditional formatting. I understand that I need to upload a Json file as a theme which will include SVG instructions for my new icons.   However, I'm ...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , I usually create an icon measure using unichar and then do conditional formatting using field value option

 

/////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

 

list : https://exceleratorbi.com.au/dax-unichar-function-power-bi/

 

more examples

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi amitchandak,

 

Thanks for your suggestion. I can see your point, but I think my problem is more with the actual icon I'm trying to upload which is simple but very specific - it's a circle with two colours in them. Any ideas how to deal with that? Thanks!