topic Acronyms in DAX Commands and Tips

Acronyms

Goudi — Mon, 26 Jun 2023 08:54:44 GMT

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!!!!

Re: Acronyms

tamerj1 — Mon, 26 Jun 2023 09:19:10 GMT

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.

Re: Acronyms

Goudi — Mon, 26 Jun 2023 13:09:22 GMT

Thanks!!