Need a help on how to filter the data on map visual with different filters using DAX

[Pradnya_Haraple]

How can we apply filters on multiple columns & reflect that on Map visual ?

Currently, I am able to filter the data on map with country filter on right by selecting any of the value from country dropdown.

How can we filter based on job domain?

[Pradnya_Haraple]

Hi - @v-rzhou-msft 

Now i am able to filter the map based on diferent filters for job domain, related roles, country, etc.

 However not able to get correct location of country. For example: China 

• Firstly, how can we get correct location of country? I have tried with Latitude & longitude but its not giving expected result.

• Secondly, we also want only one value to be displayed for china which calculates average of CL-Manager after applying group by country, job domain & related related roles.

For example : Map visual should display values of china as 2.56 (Average rating of CL-Manager by county) when none of the value from slicer is selected.

Is this possible? or what the map is displaying right now is correct one?

Thanks in advance.

[Pradnya_Haraple]

@amitchandak  - Can you please let us know if the formula used is correct or not?

GroupByCountry = GROUPBY(WorldMapLabels, WorldMapLabels[Country],WorldMapLabels[JobDomain], "Avg_Country", AVERAGEX(CURRENTGROUP(), ROUND(WorldMapLabels[CurrentLevelByManager],2)))

Now i am able to filter based on job domain & country.

Can we display the map like below if none of the filter values from job domain or country is selected.

We want the map to display average rating of manager by country if no filter value is selected.

Thanks in advance!!!

[v-rzhou-msft]

Hi @Pradnya_Haraple ,

According to your statement, I think WorldMapLabels[Country] and WorldMapLabels[JobDomain] are in the same table. Does this table relate to the table you used in Map visual? I think if [Country] can filter your visual, [JobDomain] should do this as well. Could you share a sample pbix file with us? We need to know your data model and this will make us easier to find the solution.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pradnya_Haraple]

@amitchandak  - Job domain filter is a column in used another table. Can we use columns from some other table to filter the data on existing table or visual?

Do i need to use Job domain column in Group by formula where group by country is specified?

Thanks for the help!!

[amitchandak]

@Pradnya_Haraple , Not very clear. If the data is connected, Job slicer filter should, if interactions are not disabled