WISE OWL EXERCISES
POWER BI EXERCISES
POWER BI EXERCISES
- Basic reports (10)
- Data sources (2)
- Query editor (8)
- Multiple tables (1)
- Filtering data (9)
- Drill-through filtering (1)
- Bookmarks (3)
- Charts (10)
- Other types of visualisation (1)
- Overview of maps (5)
- Calculated columns (7)
- Introduction to DAX (3)
- Creating measures in DAX (1)
- Calendars (2)
- Date functions (2)
- Roles and security (1)
- Advanced data models (4)
- Drill-through and bookmarks (3)
- Custom visuals (3)
- Parameters (5)
- Quick measures (3)
- Report themes (2)
- BI mobile (1)
- Power BI Templates (1)
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!
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:
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:
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:
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.