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
Hi,
I want to try to create a filled map chart. I have my data : Country, Year, number of things.
I click the map icon, I select the country field (if I drag the field into "Legend" I can see my countries), but the map, for this countries, don't change color.
I try with an Excel file of the book that I study (Pro Power BI Desktop) and all run correctly.
I don't understand.
Thanks for the help.
Solved! Go to Solution.
Hi Francesco,
please try to mark your country-column with the appropriate data category
You can find a Demo PBIX here.
Hope this helps 🙂
Frank
1. U have to drop the country in Legend and Location in both.
2. If your column name is not Country , then u have to set the column Data Category is "Country / Region "
This will help u sure . look the image .
If not helping u let me know i will help u sure 🙂
Thank you Frank and Baskar,
My problem was the data category!
I'm sorry, I have started to read my book only today, but I find PBI a fantastic tool. In the past I worked many years with Business Objects, but I think to find something easy and good for users like BO.
Thanks.
Hey mate,
I assume you're using the ArcGIS maps - did you
1) put the "number of things" column into the "Color" section of the map?
2) mark the country column with the data category Country/Region?
HTH,
Frank
Hi Frank,
Thanks for your help, I use the basic objects that I find in PBI Desktop. Look at the image.
Francesco
Hi Francesco,
please try to mark your country-column with the appropriate data category
You can find a Demo PBIX here.
Hope this helps 🙂
Frank
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 44 | |
| 40 | |
| 33 | |
| 31 | |
| 23 |
| User | Count |
|---|---|
| 127 | |
| 116 | |
| 90 | |
| 73 | |
| 69 |