Conditional Formatting Icons

[RichJW]

Hi all,

I'm surprised I have to post this, as I thought it would be standard with PBI.

I have a table with one column and all I require is conditional formatting on one specific number, that will apply a coloured arrow to the table, instead of any number.

I need the following: Up, Down and Double-arrowed horizontal arrow (as in no change), available in Red, Amber and Green (9 in total). Similar to these in Wingdings, but I'm not really fussy as to the style.

Yet I go into conditional formatting > Icons and there are only Green & Red Up and an Amber pointing to the right. 

This seems basic stuff, am I missing a simple way of doing this?

I'm not concerned with what visualization is used, so long as I can see the arrow.

Thanks,

Rich

[amitchandak · Accepted solution]

@RichJW , you can use Unichar with conditional formatting

refer

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

[RichJW]

Thanks @amitchandak and @FrankAT , I'll take a look.

Cheers, Rich

[FrankAT · Accepted solution]

Hi @RichJW 

take a look at the following links:

https://powerbi.tips/2019/07/icons-upon-icons/

https://hatfullofdata.blog/svg-in-power-bi-part-6-new-icon-conditional-formatting/

https://www.absentdata.com/build-custom-power-bi-kpi-icons/

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[amitchandak · Accepted solution]

@RichJW , you can use Unichar with conditional formatting

refer

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