Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I would like to plot UK postcodes onto a map to show where each sales person has customers.
I have a number of columns all filled with individual postcodes. One column for each rep.
I would like the postcodes in each column to be plotted on the graph with a different colour for each column to signify each rep.
Can this be done?
Sample data below.
KM | NM | JD | MF | MH | AA |
BL5 3QR | BD21 4LA | BH17 0RB | BL3 3WW | CH7 4TG | BL1 8HU |
BL6 5GR | BD21 5JU | BH17 0RS | BL9 7BR | CH8 7EL | BL2 6DW |
BL7 0FS | BD4 8SJ | BH21 3SN | BN2 6AH | CH8 9HE | BN15 8SU |
BL9 7HT | CV37 8LL | BH21 6RR | BT2 7FE | CH8 9HE | BN15 8TU |
BT79 9LZ | CV8 3DX | BH21 7JX | BT35 6JQ | DH7 8HJ | BN18 0HY |
Solved! Go to Solution.
Hi @Limbo1964,
In Query Editor mode, unpivot all columns. Press Ctrl key, select all columns, then, click the "Unpivot Columns" button.
Rename the new columns (in my test, it's [rep] and [postal code]) and save the changes. In data view mode, create a map like below.
Best regards,
Yuliana Gu
Hi @Limbo1964,
In Query Editor mode, unpivot all columns. Press Ctrl key, select all columns, then, click the "Unpivot Columns" button.
Rename the new columns (in my test, it's [rep] and [postal code]) and save the changes. In data view mode, create a map like below.
Best regards,
Yuliana Gu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |