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.

Software ==> Power BI  (111 exercises)
Version ==> Latest update
Topic ==> Charts  (10 exercises)
Level ==> Average difficulty
Subject ==> Power BI training
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.

You can unzip this file to see the answers to this exercise, although please remember this is for your personal use only.
This page has 0 threads Add post