Forum Discussion
Map Latitude and Longitude Color Saturation Does Not Work
I have a table in Excel with 4 columns in it. The columns show the Location Name, Latitude, Longitude, and Action Completed. The idea is that location T1 could have multiple different actions (e.g., 4) completed at that specific location. I am interested in having the color saturation being dependent on the count of the actions completed for each location. I have the map working (i.e., the bubble show up in the correct location) and the size of the bubbles will change based on the count of actions. However, for some reason I cannot get the color saturation to change based on the counted value. Please help! Thanks!
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.
