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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.