Measure for Conditional Formatting Icons instead of Background Color

[jamiers]

Hi All,

I am in the process of creating a dataset to revise a bunch of reports that I have created.  All of these reports use the same 5 files and in order to be more efficient, I am creating the dataset to improve refresh time on the server I am on.

I use the same conditional formatting to put Power BI's stock icons into a column based on a check.  Instead of pushing back numbers, it shows one of the conditional formatting stock icons:

 I see that there is a way to create a measure that does background coloring, but that doesn't work my case:

GAP Icon MN = SWITCH(
     TRUE()
     ,SUM('*MergedMCSH'[GAP √ SA]) = -1, "#f44242"
     ,SUM('*MergedMCSH'[GAP √ SA]) = 0, "#f4f142"
     ,SUM('*MergedMCSH'[GAP √ SA]) = 1, "#5ff442",
     "#FF0000"
)

How would I call the Power BI stock icons instead?

[jamiers]

Thanks for this -- is there any way to get the actual Power BI check mark?  Red X?  Yellow Flag?

[Shishir22]

Hello @jamiers ,

Not sure about that. You can search for similiar icons in the url provided in my previous reply or you can search in emojis menu by click windown + fullstop(.) button.

Please mark it as answer if it resolves your issue. Kudos are also appreciated.

[Shishir22]

Hello @jamiers ,

You can use UNICHARS() to call icons.

GAP Icon MN = SWITCH(
     TRUE()
     ,SUM('*MergedMCSH'[GAP √ SA]) = -1,UNICHAR(129528)
     ,SUM('*MergedMCSH'[GAP √ SA]) = 0, UNICHAR(129516)
     ,SUM('*MergedMCSH'[GAP √ SA]) = 1, UNICHAR(129313),
     UNICHAR(128681)
)

Refer below link for Unichar codes.

https://www.vertex42.com/ExcelTips/unicode-symbols.html

Please mark it as answer if it resolves your issue. Kudos are also appreciated.

Cheers,

Shishir