Problem with Custom Map Visual

userpowerbiii12 · ‎06-11-2023

I'm working with map visual in Power BI to show the number of employees per city when I filter by country, everything works perfectly fine. For instance , when I choose country london, my map is perfectly zoomed at the country and displaying the return value of my measure per state.

This is my measure to count the number of employees per workplace:

Employees Per Workplace = CALCULATE( DISTINCTCOUNT(FACT_TABLE[FK_EMPLOYEE]), USERELATIONSHIP(FACT_TABLE[FK_EMPLOYEE], DIM_EMPLOYEE[ID_EMPLOYEE]), USERELATIONSHIP(FACT_TABLE[FK_WORKPLACE_REGION], DIM_WORKPLACEREGION[REGION_ID]))

Now, I actually found another beautiful and interesting visual using the custom map from this Youtube tutorial.

https://www.youtube.com/watch?v=OQuKwy6eEDk

I actually downloaded the JSON file and I noticed that it only has names of countries. In the youtube example, when it filters by continent , it shows the distribution of a measure (Percentage of population) and works correctly. However for my case, I'll be filtering by country, and I'll be seeing for each city of the selected country how many employees do I have. Except that when I filter , it's not showing anything. The only case that it shows is when I choose "Luxembourg" which is the name of a country but also the name of a state/city.

I even tried to add longitude and latitude in my dataset and set them to the respective categories. I also set the country and city (which I have in 2 separate dimensions) to the respective categories

**So I don't know If the issue could be with the JSON file I'm using ? **

Here's the link to PBIX file: https://drive.google.com/file/d/1VqiLlilSkNzBX5Y6S-Hsr1N2zApVci7k/view?usp=sharing

Here's the JSON file: https://pastebin.com/wQTprvyX