Forum Discussion
Helper IIHave errors when use average long and lat on map
Ok then what I would suggest is to rather remove the item from location.
Put your Product Name in the Legend Area.And then leave the Lat and Long as the values that they are.
Then if you use the State as a Slicer you will be able to see the purchases in each state.
Then if you wanted to see who was the Max or Min, you could create a table with all the relevant details. The table will filter based on what you select in the slicer. As well as in the table you can then change the order by clicking on the column value (which will enable the table to sort by largest purchase)
Super UserHi Gracie
I took your data and imported it.
What I then did was I went to the Modeling tab and under the Properties changed the Data Category to Latitude for Latitude as well as Longitude with Longitude. I also changed the Default Summarization from Sum to Don't Summarize as shown below.
I then created the Map and put in the Lat and Long and then filtered to FL and this looks correct based on your data.
It would appear that possibly the Lat and Long properties were not set for the mapping?
Helper IIThank you. But I want the most sold product in the location field so that when I display the label, it will show on the map like the picture below. However, in order to do that, I have to use average of longitude or latitude which will cause wrong location on the map. Do you know how can I make sure the right location as well as label display?
- GilbertQJust so I understand correctly you are wanting to map the most products sold in a particular region?
- Gracie
Yes. I want to show the product name as label in the map.
- GilbertQ
Ok then what I would suggest is to rather remove the item from location.
Put your Product Name in the Legend Area.And then leave the Lat and Long as the values that they are.
Then if you use the State as a Slicer you will be able to see the purchases in each state.
Then if you wanted to see who was the Max or Min, you could create a table with all the relevant details. The table will filter based on what you select in the slicer. As well as in the table you can then change the order by clicking on the column value (which will enable the table to sort by largest purchase)
Go to query editor and change Lat and Long to text data type and save and close .. In power BI desktop go to modeling tab and change Lat to Lat and Long to Long under data category also make them Don't summarize , then place the fields in the respective tabs , Now you will see them as first lat and first long click on the down arrow button and make it to Don't summarize then you will see the correct lat and long in the visulazation..
Hope this will help you..