Exercise: Show BBC1 viewing figures by genre, using chart grouping

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 the course listed below!

Category ==> Power BI Desktop  (26 exercises)
Topic ==> Charts  (4 exercises)
Level ==> Average difficulty
Course ==> Power BI Desktop
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.

Create a new Power BI Desktop file, and load the data from the workbook in the above folder (you can get a link to the figures here, should you be interested in further research!). 

Use Query Editor to display the name of each program and its viewing figures:

Viewing figures

You'll need to split the program name by the ( symbol. All good practice!

Create a pie chart showing the average number of viewers by program:

Pie chart

This pie chart probably makes sense - it shows the share of each program of total viewing figures (for the top 10 programs on the BBC in the first week of November 2016).

Create four groups for the programs:

The four groups

Four groups that you could create. You can start the process off by right-clicking on one or more of the pie chart slices and choosing Groups.


Use these to show a far less meaningful (albeit prettier) pie chart:

Pie chart by genre

Is it meaningful to show the average viewing figures by genre? Probably not, but it makes for a good exercise.


Save this as Demelza for PM, and close down the Power BI instance containing it.

This page has 0 threads Add post