Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
551 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Software ==> | Power BI (160 exercises) |
Topic ==> | Charts (13 exercises) |
Level ==> | Average difficulty |
Subject ==> | Power BI training |
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.
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.
You can find other training resources for the subject of this exercise here:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.