Acronyms

[Goudi]

I am new to power Bi and I have the following question:

I have a table "table1" with a column called "city" that uses acronyms and this column I use it as a filter. My doubt if instead of acronyms in the filter that applies I want to use the whole word what formula should I use? example:

CITY         TOTAL
bcn               8
mad              9
lon                7
ber                7

How I want it to be displayed in the report

CITY                     TOTAL

BARCELONA            8
MADRID                   9
LONDON                  7
BERLIN                      7

Thanks!!!!

[Goudi]

Thanks!!

[tamerj1]

Hi @Goudi 

Just create a 'City' table which contains two columns [City Name] and [City Short Name] then connect [City Short Name] with city column in the main table using one directional 1:* relationship. You can the place 'City'[City Name] in the table visual instead of the original city colum.