Forum Discussion
Map Latitude and Longitude Color Saturation Does Not Work
Thank you for your help. To answer your question, you are correct that I am repeating the lat and long for each completed action. The location table lists each Turbine name and it's corresponding lat and long. It is used as a VLookup so that I when an action is completed, I say what turbine it was completed at and the lat and long populate. The Locations table is not used in Power BI because I couldn't get it to work, but now I might be able to since I have a better understanding of how this all works.
I was able to get this to work. What I had to do was enter a location. I the "Turbine" column there (this column consists of values T1 through T100 and those values are repeated if multiple actions are completed at each location). Once that is done, I received an error. This error said I can continue to use Lat and Long if I set them to the average. Note that this does not average the values and there was no ill effects from changing it to average rather than sum. At this point, I put Count of Action in the Color saturation box and the map now performs as desired. Thanks again for all of your help.
I am doing this with Power BI online if that makes any difference. I don't think it should though.
SeanCommunity Champion
mathysbt I couldn't duplicate this with my data sets - So created a test file - and was able to duplicate
So if a location has 4 actions you are basically repeating the lat and long 4 times
What is in the Locations table do you have the Lat & Long info there AND are the Locations unique.
Thank you for your help. To answer your question, you are correct that I am repeating the lat and long for each completed action. The location table lists each Turbine name and it's corresponding lat and long. It is used as a VLookup so that I when an action is completed, I say what turbine it was completed at and the lat and long populate. The Locations table is not used in Power BI because I couldn't get it to work, but now I might be able to since I have a better understanding of how this all works.
I was able to get this to work. What I had to do was enter a location. I the "Turbine" column there (this column consists of values T1 through T100 and those values are repeated if multiple actions are completed at each location). Once that is done, I received an error. This error said I can continue to use Lat and Long if I set them to the average. Note that this does not average the values and there was no ill effects from changing it to average rather than sum. At this point, I put Count of Action in the Color saturation box and the map now performs as desired. Thanks again for all of your help.
- DataDiva
Advocate II
I'm having the same exact problem but your solution did not work for me! My color saturation and size are not changing at all. I've tried using all manner of different fields and measures to see if that helps for color/size but nothing is working... Any ideas...? i am using lat and lon, I do have many occurrences of each pair of lat-lon but if I chose a location and set the lat-lon to average, the color/size still do not work :(
