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 ,
My dataset contains only latitude and longitude along with sales data.
When i try to visualize it in map chart , sales value shows one unique value across each lat/long locations..Ideally, it should varies acroding to lat/long locations. Kindly provide a solution or trick through whihc i can achieve it.
Do i need to create a measure which calculates sales specifically based on lat/long values?
Hi @Anonymous
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Rico Zhou
Hi @Anonymous
Due to I don't know your data model I build a sample table to have a test.
And build a map visual:
It works well. Could you provide me your data model and show me the result you want, and that will make it easier for me to understand your requirement.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous
Use a regular map from the visuals. Place Lat and Long then set their aggregation to "Don't Aggregate"
For the Size of the Bubble, you can drag and drop either a simple total sales measure or the sales column from the table make sure it is set as SUM if it is not a measure.
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous , have used Sales in size (In case this MAP or Azure Map)
If long and lat is in other table , make sure join with you sales table is correct
@amitchandak I have used it in size and there is no other table through which i joined
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 |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |