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 nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
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 |
|---|---|
| 16 | |
| 14 | |
| 12 | |
| 9 | |
| 7 |
| User | Count |
|---|---|
| 39 | |
| 38 | |
| 34 | |
| 28 | |
| 20 |