Forum Discussion
How to create query function for adding latitude and longitude to my data
HimaBindhu,
You would need to prepare latitude and longitude data in your data source, then refresh in Power BI Desktop to bring new columns.
In your scenario, why not directly create map visual using country and province fields? You can set data category for your fields to proper category(country or province).
Regards,
LydiaAs Lydia said, you will need to prepare your Lat/Long coodorindates in your data sources, even if that is a simple spreadsheet you can import and merge with your data.
To answer your question Anonymous the State/Province selection is problematic as it often gets the completely wrong place in the world. A good example is the data point "Orange" which is a city in New South Wales in Australia. Power BI commonly gets it confused with Orange County in America. Often Lat/Long is the only method of guarenteeing the expected outcome.
HimaBindhu,
You would need to prepare latitude and longitude data in your data source, then refresh in Power BI Desktop to bring new columns.
In your scenario, why not directly create map visual using country and province fields? You can set data category for your fields to proper category(country or province).
Regards,
Lydia
As Lydia said, you will need to prepare your Lat/Long coodorindates in your data sources, even if that is a simple spreadsheet you can import and merge with your data.
To answer your question Anonymous the State/Province selection is problematic as it often gets the completely wrong place in the world. A good example is the data point "Orange" which is a city in New South Wales in Australia. Power BI commonly gets it confused with Orange County in America. Often Lat/Long is the only method of guarenteeing the expected outcome.