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.
Color Details 1 of 2Color Details 1 of 2Size WorksSean
I don't have anything in the legend. I have attached some screenshots to give a better idea of what I am doing. Thanks!
Community Championmathysbt You need Count of Action in both Size and Color Saturation at the same time drag the filed to both places!
This should do it. Let me know.
This did not work. All that it did was make the bubbles size increase, but the color is still unchanged.
I am doing this with Power BI online if that makes any difference. I don't think it should though.
- Sean
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.