Displaying icon based on text value in a column

Anonymous — Tue, 05 Jul 2022 09:51:31 GMT

Hello guys,

I have a column which stores file status as a text string called Status. I want to display only an icon based on this field value. I tried conditional formatting, but for values it doesn't show me the option of picking an icon.

I am a complete newbie, but my idea was to add a numeric column Status value, based on the text value, and then in conditional formatting format style based on rules instead of values. How do I create that column, so that for example for text value X and Y it stores 1, and for Z it stores 2, for A it stores 3 etc.?

I should add that I am using live connection, so I can't just add a column, I think it needs to be a measure.

Re: Displaying icon based on text value in a column

amitchandak — Tue, 05 Jul 2022 10:30:10 GMT

Anonymous , You can create an unichar measure and use that as a measure

example

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

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

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

topic Displaying icon based on text value in a column in DAX Commands and Tips

Displaying icon based on text value in a column

Re: Displaying icon based on text value in a column