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 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
Solved! Go to 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)
Then you can create a map visual with: 'value' field on 'Location', 'attribute' to 'Legend', Sale amount to 'Size'.
Regards,
Xiaoxin Sheng
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)
Then you can create a map visual with: 'value' field on 'Location', 'attribute' to 'Legend', Sale amount to 'Size'.
Regards,
Xiaoxin Sheng
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 |
---|---|
109 | |
97 | |
80 | |
67 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |