Problem to display emplacement defined in different columns on a map

[NCLSOG]

Hello, 

I want to place on the map different emplacements.

My localisations  are defined in 5 different columns. 

Localition	APM_VILLE_1	APM_VILLE2	APM_VILLE3	APM_VILLE4
PARIS	ROME	RIO JANEIRO	LOS ANGELES	TORONTO
NEW YORK	TOKYO	ROME
DUBLIN

I've added the 5 columns in the field emplacement. (see screenshot below 1 / 2 / 3 / 4 / 5) 

But, only the first column is taked in consideration and displayed on the map. The informations are not cumulated. 

How can display the cities saved in the different columns ?

Thx for your feedback

[Anonymous · Accepted solution]

Hi @NCLSOG,

I'd like to suggest you do 'unpivot columns' on these fields, then you cna use attribute and value fields to design visualization instead of the values that stored from multiple value fields.

Unpivot columns - Power Query | Microsoft Learn

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

Hi @NCLSOG,

I'd like to suggest you do 'unpivot columns' on these fields, then you cna use attribute and value fields to design visualization instead of the values that stored from multiple value fields.

Unpivot columns - Power Query | Microsoft Learn

Regards,

Xiaoxin Sheng

[NCLSOG · Accepted solution]

thx a lot