Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Brand new to filled map visual (appology in advance). I place two character STATES column in LOCATION field in Power BI Service, and Map recognizes as Countries. I have tried full state name and changing column names. For example, CA is seen as Canada NOT California. I used column headers as TERRITORY and US STATES. Same results.
Thank you!!!!
Solved! Go to Solution.
Try adding the Suffix ",US" to CA so, "CA,US"
@etescher you can achieve this by going into the Data tab, clicking New column the pasting in the following, ensuring you change "Table Name and Column Name to reflect your own dataset.
NewColumn = CONCATENATE('Table Name'[Column Name],",US")
You can also go into the map settings and change Location to "one County", US.
Try adding the Suffix ",US" to CA so, "CA,US"
@etescher you can achieve this by going into the Data tab, clicking New column the pasting in the following, ensuring you change "Table Name and Column Name to reflect your own dataset.
NewColumn = CONCATENATE('Table Name'[Column Name],",US")
Hi Karlos,
Thanks for the attempt. I loaded field concatenated. Behavior was that entire US highlighted as one object. If I unselected one state, from filter, none of map highlighted. I wonder if there is something unique to POWER BI SERVICE. Options you chose like layers were not available to me.
Thanks for trying,
Eric
Upload a copy of your PBIX file and I'll take a look .
I just noticed that my screenshot above is incorrect, as it had Boundaries selected under "represent Locations as", you need to ensure this is "Points"
Sadly, I am not able to take advantage of your expertise because I am using Power BI Service (Cloud). It appears NOT capable of downloading PBIX file.
Thanks!
Eric
Note 3 fields with GLOBES. It appears Power BI sees data as it should and recognizes location. Fullstate is the full text name for each state. I keep trying to offer every clue I think of.
See if you can reverse what I've done. Click on the link below to download the PBIX file, then upload it to the service.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
55 | |
39 | |
33 | |
31 | |
25 |