Power BI | Charts exercise | Create a KPI and a drill-down bar chart for skyscraper data

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

The answer to the exercise will be included and explained if you attend one of more of the courses listed below!

Software ==> Power BI  (88 exercises)
Version ==> Latest update
Topic ==> Charts  (10 exercises)
Level ==> Average difficulty
Courses ==> Introduction to Power BI  /  Fast track Power BI/DAX
Before you can do this exercise, you'll need to download and unzip this file (if you have any problems doing this, click here for help).

You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Open the Power BI report (not the Excel workbook) in the above folder:


As the text box at the top of the reports says, this contains a list of skyscrapers taken from Wikipedia.

To whet your appetite, create a cheeky card to show the number of skyscrapers:

Card counting buildings

You'll need to turn the Category Label off and the Title on to get this effect.


Create a bar chart comparing the number of buildings for each country:

Bar chart

Your chart should show data labels inside the bars, and have conditional formatting to show countries with more skyscrapers in darker colours.

Add the City column to the chart and turn on drill mode.  When you click on a bar in the chart you should see a count of the number of skyscrapers for each city in the country you've clicked on:

USA city buildings

For example, this is what you should see when you click on the USA bar.

Save your report as Symbols of what though, and close it down.

This page has 0 threads Add post