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)
Helper IIYes. I want to show the product name as label in the map.
Super UserOk 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)