Map Help

[Anonymous]

Hi guys,

I'm after some mapping help - my apologies if this question has been asked before.

In my dataset I have sales orders. Included in the data for each sales order are postcodes of where the sales orders were delivered to and also which of our many depots the orders were delivered from.

What I'm trying to achieve is to plot a map which includes sales (£) and the post codes of where the orders where delivered to and from.

So far I have plotted a map which shows sales (£) by delivered to post code. I am now trying to overlay the 'delivered from' postcode onto the map as a "dot" so the user can see where orders have been delivered to and where the depot was that the orders came from. I don't want to drill into the map, but show both postcode types.

Does anyone know if this is possible?

Thank you,

Martyn

[Anonymous · Accepted solution]

HI @Anonymous ,

You can enter to query editor and do 'unpivot columns' on your location fields to transform them into 'attribute' and 'value' fields. (location type, location address)

Unpivot columns (Power Query) 

Then you can create a map visual with: 'value' field on 'Location', 'attribute' to 'Legend', Sale amount to 'Size'.

Regards,

Xiaoxin Sheng