Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Hello, I have a problem. On having showed a map of Spain with information for provinces, there are provinces that me appear in america. I have put a filter in " visual level filters " with country: Spain and categorized as country, but it is not solved. Can someone help me? Thank you
Solved! Go to Solution.
Hi @lbarreiro,
There are two easy ways to make it right.
1. Add a new Calculated column "Country province". Pay attention to the space following "Spain".
Change its "Data Category" to "Place".
CountryProvince = CONCATENATE ( "Spain ", [Province] )
2. Add a Calculated column "Spain".
Chang its "Data Category" to Country.
Best Regards!
Dale
Hi @lbarreiro,
There are two easy ways to make it right.
1. Add a new Calculated column "Country province". Pay attention to the space following "Spain".
Change its "Data Category" to "Place".
CountryProvince = CONCATENATE ( "Spain ", [Province] )
2. Add a Calculated column "Spain".
Chang its "Data Category" to Country.
Best Regards!
Dale
Thank you! I could made it.
| User | Count |
|---|---|
| 15 | |
| 14 | |
| 12 | |
| 11 | |
| 8 |
| User | Count |
|---|---|
| 44 | |
| 40 | |
| 29 | |
| 28 | |
| 22 |