Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey, has anyone had an issue when they import a excel sheet, it automatically makes formulas for the Latitude and Longitude fields? When ever I try to add the sheet in, it takes the two columns (decimal field) and creates a formula; and when I add the Latitutde and Longitude in, there is no way to remove the sum (don't summarize)... This is a problem because it prevents me from displaying the different locations of all the names that are placed into the map. Did I miss something?
Solved! Go to Solution.
Hello,
Thank you for the solution, however I found a way to fix it too. You can go to the longitude and latitude fields, and change the field type to Count (Distinct), then you can select the "don't summarize" option in that dropdown menu. I did this for Longitude and Latitude which fixed the issue and allowed them to be rendered.
-Alex b.
@Alexand3rBr try placing a field in the in the Size field (you can also then use the Location field)
Look at my answer here (the aggregation of Lat and Long is not preventing you from plotting the locations)
Hello,
Thank you for the solution, however I found a way to fix it too. You can go to the longitude and latitude fields, and change the field type to Count (Distinct), then you can select the "don't summarize" option in that dropdown menu. I did this for Longitude and Latitude which fixed the issue and allowed them to be rendered.
-Alex b.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |