Tips on adjusting the scaling of visual objects on...

Scenario:

The Bing Map object in Power BI Desktop displays a wide area when you select a different province with the Slicer. To make the map roughly zoom in to the province level, you can use different levels of geographic locations or use latitude and longitude instead of only province in the Bing Map object. You can also use the Filled map feature of the Azure Map object.

Current result:

In Power BI Desktop, drag only the Province field to the Slicer visual object and the Bing Map visual object.

After selecting Jiangsu in the Slicer visual object, the page effect is as follows:

As you can see, the display is wider, even to Taiwan and South Korea. I don't want to show such a wide area, I want to show the approximate area of Province after Slicer filtering.

Expected result:

I'd like to have the user select Province in Slicer and then have the area displayed in the Map be roughly the Province range.

Implement a visual effect similar to Filled Map's zoomed range without having to add a border:

Sample data:

Province table：

Province

Sichuan

Jiangsu

Yunnan

Guizhou

Fujian

Shandong

How:

Solution 1:

Add hierarchical data, such as City, to each Province of the original data.

AppendTable table:

Now, you can see that there are different cities' data in each of the same Provinces, and you can add more data if you want a more accurate range of Provinces to be displayed.

Set the Data category of Province and City to State or Province and City.

Drag the Province field of the Province table into the Slicer visual object and the City field into Location of the Bing Map visual object.

Select Jiangsu in Slicer, the display effect is as follows:

Solution 2:

Go online and search for the Latitude and Longitude corresponding to each Province in the raw data table. However, if there is only one Latitude and Longitude corresponding to each Province in the data table, it will show a too small range in the map. Therefore, adding multiple Latitude and Longitude data to the same Province will be better.

Table table：

Set the Data categories for Latitude and Longitude to Latitude and Longitude.

Drag the Province field of the Province table into the Slicer visual object.

In the Bing Map visual object, remove the Province field and drag the Latitude and Longitude fields of the Table table into the Bing Map visual object.

Select Jiangsu in Slicer, the final page visual effect is as follows:

If you want to display a more detailed Province range, you can add multiple latitudes and longitudes to the same Province and then use this method.

Solution 3:

This type of requirement can also be achieved using Azure Map.

Drag the Province field of the Province table to Location, at which point the display looks as shown below:

Enable the Filled map feature under the Format tab:

At this time, the display effect is shown below, you can see that this method is also the realization of the demand.

Summary:

When using Bing Map in Power BI Desktop and only having Province field in the map, if the user selects Province in the Slicer, the Map visual object will display a wide range with low accuracy.

If you want to display an approximate range of Province in the Bing Map visual object, you can use a hierarchy of geographic locations, or replace the Location fields with Latitude and Longitude, or enable the Filled map feature tab of the Azure Map visual object.

Hope this article can help you solve similar problems.   

Author: Daisy Yang

Reviewer:Ula and Kerry