Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register 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 |
---|---|
35 | |
22 | |
21 | |
14 | |
13 |
User | Count |
---|---|
26 | |
19 | |
18 | |
18 | |
16 |