Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
User | Count |
---|---|
107 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |