Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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)
Solved! Go to Solution.
pls check if this is helpful
Proud to be a Super User!
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
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.
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
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.
pls check if this is helpful
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
68 | |
64 |
User | Count |
---|---|
209 | |
118 | |
116 | |
81 | |
74 |