Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
elseoutzen
Regular Visitor

UNICHAR for country flags in a column

Is it possible to add a colum in a table with a UNICHAR for a country flag ? 

I manged to use url, however flags have diffrent sizes, URL can change etc.

So my idea was to use UNICHAR instead . but I can´t get it working . 

 

Examples:

UNICHAR for Denmark is ; 

Denmark

U+1F1E9 U+1F1F0

&#127465 &#127472

 

UNICHAR for belgium is:

Belgium

U+1F1E7 U+1F1EA

&#127463 &#127466

 

 

Column when using url: 

FLAG = IF('MD '[COUNTRY] = "DK", "http://www.geonames.org/flags/x/dk.gif" ,

IF('MD'[COUNTRY] = "BE", "http://www.geonames.org/flags/x/be.gif" ,
"NA"))
 
Endresult should be : In a  Matrix to show me the country flags in the columns and the measure in the rows - like below with URL 
 
elseoutzen_0-1680086597534.png

 

 
Anyone know how to do the same but with UNICHAR?
 
2 REPLIES 2
lbendlin
Super User
Super User

UNICHAR for Denmark is ; 

Denmark

U+1F1E9 U+1F1F0

&#127465 &#127472

In DAX that is "DK"  albeit in weird font. Not a flag?

get returned "DK" as letters . 

i am searching for a code that will return me a flag icon. (Not a letter )  
do you know how ? 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.