1

Load data tables

Launch the PowerBI App and load your data tables.
Ensure to include Course enrolment ID to return distinct enrolment records.
Include columns for Month and Year, extracted from the date and time fields. Learn more: How to prepare your data in PowerBI.

2

Create a table

Select the columns such as Year, Month, and Course Enrolment ID by clicking the checkboxes.
The table will be ordered in the same sequence.

3

Display Course Enrolment ID count

Click on the table > Visualizations > Columns
Click the down arrow next to courseenrolmentid
Change the value to display the Count instead of Sum of Course Enrolment ID.

4

The table will be updated to display the number of Course Enrolments by year, by month. The screenshot indicates there was 1 enrolment in Jan 2015 and 32 enrolments in Jan 2017.

5

Create a Clustered Column Chart

Copy the current table using copy and paste.

6

Select the new table > Visualizations > Clustered column chart.

7

Put the month and year columns into the x-axis
Put the count of courseenrollmentid into the y-axis

8

A clustered column chart will now display the course enrolments by months and years.

9

Click the Drill up option on the top right to summarise the graph by year.

10

For a month-by-month summary of a specific year:

Click the down arrow (Drill down option)
Click on a specific year on the graph.

11

If you click the two arrows pointing down you see the whole view with years and months at once. This system is called Drill Down.

12

To show the table and graph at the same time:

Drag the table and graph side by side.
This creates a view with:
- A graph of the month-on-month course enrolments for a specific year
- The corresponding values in table form