Acronyms

Question

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&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TOTALbcn&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8mad&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9lon&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7ber&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7How I want it to be displayed in the reportCITY&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TOTALBARCELONA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 8MADRID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9LONDON&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7BERLIN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7Thanks!!!!

tamerj1 · Answer

Hi&nbsp;Goudi&nbsp;
Just create a 'City' table which contains two columns [City Name] and [City Short Name] then connect&nbsp;[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.&nbsp;

goudi · Answer

Thanks!!

Forum Discussion

Acronyms

2 Replies

Related content

Understanding UDF in Microsoft Fabric: Two Concepts, One Acronym

Searching on acronyms

How to use Text Function to keep the Acronyms in capital and rest of the words in small letters

Decision tree visual

Re: List of valid values for Country\Region? Continent?