Rajendra Gupta

Enlighten World Flag Slicer in Power BI Desktop

November 21, 2018 by

Power BI has a rich set of visuals to represent data according to our requirements. These custom visuals make it easy for us to highlight data effectively to understand and share the data in reports. We have learned many customized visuals so far in ongoing series of Power BI Desktop.

In this article, we will explore Enlighten World Flag Slicer visual for Power BI Desktop.

Import Data for Enlighten World Flag Slicer in the Power BI Desktop

Suppose we want to prepare a report to examine the 2018 Asian Games medal table using Power BI Desktop. In the report, Enlighten World Flag Slicer is helpful to visualize the data from the dataset and represent country names with their flags. This represents the country with flags symbol and we can filter out the report for the country just by click on the respective country flag.

In this article, we will take data from the Wikipedia 2018 Asian Games medal table. In Power BI Desktop, we can directly fetch data from the web data source and prepare chart from it without exporting data into excel or flat file format. Launch the web data source from Get Data -> Web

Import data in Power BI desktop

In the basic option, enter the URL of the web page containing data table and click OK.

Enter the URL to import data

Preview the data. We can see in the column ‘NOC’ country name are shows along with abbreviations, for example, China (CHN). We need to remove the abbreviation so that we can generate the enlighten world flag slicer. To edit the data, click on ‘Edit’

preview the data

It opens Power BI editor to make changes in the data.

Edit the Data set

We can split the column to get rid of abbreviations. Click on the ‘Split Column -> By Delimiter’

Split column

It automatically selects the delimiter. However, we can select or enter delimiter. We can also choose to split at leftmost/rightmost or split at each occurrence of the delimiter. Proceed next by clicking on ‘OK’.

Split column by delimiter

It splits the column based on the delimiter condition specified.

Split column by delimiter

We do not need this column, so right click on the column and remove it.

Remove unwanted column

Also, rename the column name from ‘NOC’ to ‘Country’. Close and apply to save changes.

Save changes

We can see dataset now to prepare visuals as required. Our sample dataset contains a list of countries, and their medals tally (Gold, bronze or silver).

data set in Power BI Desktop

Before we create the enlighten world flag slicer visual, let us create ‘Map’ chart from our data set. Double click on ‘Map’ chart icon as shown and adjust the chart height width in the bottom part of the screen.

Create enlighten world flag slice

Now, drag the column fields as below

  • Location -> Country
  • Size -> Total

It generates the map chart as shown here. For the countries listed in our data set, it puts a dot to represent the country.Create enlighten world flag slice

In this chart, data is shown for all countries together. We can get the data for Individual County if we hover the mouse over the dots.

Now, we will import the ‘Enlighten World Flag Slicer’ visual from the Marketplace. Search it and add as shown below.

Import enlighten world flag slice

You can see the icon as a flag shape in the visualization area.

Import enlighten world flag slice

Double click on it and adjust the size on the upper side of the blank screen.

Create enlighten world flag slice

Click on the ‘Enlighten World Flag Slicer’ and select the ‘Country’ from our dataset. It shows the flag of each country listed in our data set.

Create enlighten world flag slice

Now, if we click on any particular country, the map auto zooms to that particular country. For example, here I clicked on ‘China’ and you can see in the chart ‘China’ is zoomed in.

enlighten world flag slice

Similarly, let us click on another country say ‘Malaysia’ and map chart is again zoomed on that country.

enlighten world flag slice in Power BI

If we hover the mouse over the dot representing country, you can see details of medals won by that particular country. For example, below you can find details of ‘Malaysia’ country medals.

enlighten world flag slice in Power BI

Now, we will do a little bit of formatting for our enlighten world flag slicer visual. In the format area, click on ‘Title’ and modify the title properties such as font color, background, alignment etc. This will provide a better look for our chart title.

enlighten world flag slice in Power BI

As shown above, when we click on any particular country, map redirects to that country. We cannot find the selected country from the flags since it is not highlighted. Therefore, let us add another chart ‘Card’ into the area.

enlighten world flag slice in Power BI

Select the chart and click on a country from the dataset. Now, it will show the name of the country we selected from the flags. For example, below it shows Malaysia.

enlighten world flag slice in Power BI

Similarly, below it shows county ‘India’

enlighten world flag slice in Power BI

Below we can see Indonesia along with the medals tally for it.

enlighten world flag slice in Power BI

We still have one issue with our report. In the above example, you can notice that whichever country we select, it shows ‘First Country’ below the country name. In order to address this, let us create another ‘Measure’ column in the dataset. Right, click on the dataset and select ‘New Measure’.

Here, we will use DAX codes to prepare a measured column:

  • CALCULATE: It evaluates an expression in a context that is modified by the specified filters
  • CONCATENATEX: it concatenates the result of an expression evaluated for each row in a table

This is interactive to write DAX queries, as soon we write, it guides us with syntax, options.

enlighten world flag slice in Power BI

Therefore, the formula for the measured column is as below

Measure = CALCULATE(CONCATENATEX(‘2018 Asian Games medal table’,’2018 Asian Games medal table'[Country],”,”))

enlighten world flag slice in Power BI

Rename the column from Measure to ‘SelectedCountry’.

Now, map the ‘Selectedcountry’ column in the chart. It shows all countries name if we do not select the country, else only that particular country name is shown.

Select any country and we can see that it shows our new column name instead of the first country below the selected country name.

enlighten world flag slice in Power BI

Suppose, we want to filter the records based on top 5 countries. We need to make a separate section and display these top 5 countries flags. Adjust the chart size and insert another enlighten world flag slicer as shown here.

enlighten world flag slice in Power BI

In the new enlighten chart, map the column ‘Country’.

Currently, it is showing all flags in the new enlighten world flag slicer chart. We want to display only the top five countries chart here, so in the ‘Visual level filter’ section, select Top ‘N’.

Enter the number of items we want to show. Below this, we can select how to want this filter to apply. For example, in my example, I want to select top countries based on the total number of gold medals. You can see now only top 5 countries flags are displayed.

Now, this chart works in two ways. If we click on the country flag, in the top section, the new area also shows that country flag and map redirects to that particular country.

Click on the blank area and it removes the filter on the county flag.

In another way, click on the flag from the top five country flag, and the top chart shows only that country flag instead of all countries.

Format Enlighten World Flag slicer

  • Data labels: By default, ‘Data labels’ setting is ‘On’. It shows the country name below the flag. If we change this to ‘Off’, we cannot see the country name:

If we change data labels back to ‘On’, we can control the color and the font size for the countries name. By default, data labels show the country name.

We can change it to show the value of another field also. For example, in below example, we can see the ‘Gold’ medals count below the flag names.

Let us change it back to the country name and look out for the other formatting option.

  • Orientation: By default, orientation is set to horizontal.

If we change it to ‘Wrap’ mode, the flag comes closer to each other as shown here.

  • Show Shadow: By default, the shadow section is ‘On’. It shows the border around the flag.

If we disable the show shadow, it does not show the border. We should not make this change. As you can see if we remove the border, the country flag looks inappropriate.

Conclusion

The Enlighten World Flag Slicer represents each county with its flag and provides ability to filter out the results for any particular country. You can explore this visual into Power BI Desktop. We will continue the series of exploring customized visuals in Power BI Desktop in future articles.

Table of contents

Power BI Desktop Interactive chord diagrams
Power BI Desktop Pulse Charts
How to create a Word Cloud generator in Power BI Desktop
Power BI desktop Mekko Charts
Hexbin Scatterplot in Power BI Desktop
Candlestick chart for stock data analysis in Power BI Desktop
Enlighten World Flag Slicer in Power BI Desktop
Flow Map Chart in Power BI Desktop
Ask a Question feature in Power BI Desktop
Power BI Desktop Q&A data interaction examples
Power BI Desktop and Python; like Peanut Butter and Chocolate
Power BI Desktop Pie Chart Tree
Importing data from a PDF file in Power BI Desktop
Rajendra Gupta
Latest posts by Rajendra Gupta (see all)
PowerBI

About Rajendra Gupta

Hi! I am Rajendra Gupta, Database Specialist and Architect, helping organizations implement Microsoft SQL Server, Azure, Couchbase, AWS solutions fast and efficiently, fix related issues, and Performance Tuning with over 14 years of experience. I am the author of the book "DP-300 Administering Relational Database on Microsoft Azure". I published more than 650 technical articles on MSSQLTips, SQLShack, Quest, CodingSight, and SeveralNines. I am the creator of one of the biggest free online collections of articles on a single topic, with his 50-part series on SQL Server Always On Availability Groups. Based on my contribution to the SQL Server community, I have been recognized as the prestigious Best Author of the Year continuously in 2019, 2020, and 2021 (2nd Rank) at SQLShack and the MSSQLTIPS champions award in 2020. Personal Blog: https://www.dbblogger.com I am always interested in new challenges so if you need consulting help, reach me at rajendra.gupta16@gmail.com View all posts by Rajendra Gupta

168 Views