Unable to add icon or symbol base on formula on table

[Jimesh_Makwana]

Hi,

I create table on power bi, i want to add formula as below to column, Based on on output it will show symbol if criteria is match.

Formula - =IF(AND(K81=100%,Y81=100%,U81=100%),1,0)

[ryan_mayu · Accepted solution]

pls check if this is helpful

https://learn.microsoft.com/en-au/power-bi/create-reports/desktop-conditional-table-formatting?wt.mc...

[v-jianpeng-msft · Accepted solution]

Thanks @ryan_mayu 

Hi, @Jimesh_Makwana 

Has your current problem been solved? You can find the decimal code corresponding to your flag on the Internet, e.g. 128681 corresponds to:

Then use the UNICHAR function provided by Power BI:

flag = IF([Sales amount]>=200,UNICHAR(128681))

Here are the results:

If you are not familiar with this function, then you can click on the link below to learn it:

UNICHAR function (DAX) - DAX | Microsoft Learn

UNICHAR - DAX Guide

DAX UNICHAR Function in Power BI - Excelerator BI

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu · Accepted solution]

pls check if this is helpful

https://learn.microsoft.com/en-au/power-bi/create-reports/desktop-conditional-table-formatting?wt.mc...