Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
The names of cities in this dataset are misspelled. How to find the cities based on longitude and latitude given in the dataset?
Hi, @MihirK
If your dataset contains latitude and longitude fields, Power BI can leverage those fields to accurately identify locations. In Power BI Desktop, drag the latitude data field to the Latitude section under Visualizations, and do the same for the longitude data in the Longitude section.
This step ensures that Power BI uses precise geographic coordinates to identify city names. For more details, see the documentation on map tips and tricks:
Tips and Tricks for maps (including Bing Maps integration) - Power BI | Microsoft Learn
Power BI integrates with Bing for geocoding, which helps identify city names based on latitude and longitude. Make sure your data model is set up correctly in order to use this feature effectively. For more information about this, see the Power BI documentation:
Tips and tricks for creating reports in Power BI - Power BI | Microsoft Learn
Data categorization in Power BI Desktop - Power BI | Microsoft Learn
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
97 | |
88 | |
76 | |
70 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |