Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello,
Power BI Desktop can recognize a column with geographic data, but a City column with a formula [City] & ", " & [State], it cannot recognize. You can see in the sample: https://app.powerbi.com/groups/me/getdata/samples/retail-analysis-sample.
I do not know why it does not display information when I choose City column for Location in the page Overview or New Stores.
May you please explain?
Thanks,
@Windynite , I do not think we can access it, can you please share a screenshot
Try like Country , State , city
or Country , City
refer
https://www.biinsight.com/how-to-overcome-map-related-issues-in-power-bi-power-view-and-power-map/
@amitchandak These following pictures are geographic data and map visualizations I am using. Thanks for your referring.
| |
|
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 53 | |
| 42 | |
| 34 | |
| 34 | |
| 21 |
| User | Count |
|---|---|
| 143 | |
| 125 | |
| 100 | |
| 81 | |
| 63 |