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
562 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 a blank Power BI file and import data from Gym Class Data.xlsx from the folder shown above.
Add a Line chart with Class on the X axis and Attendees on the Y axis.
Change the label on the Y axis to read Total Attendees.
The basic line chart.
Now make the following formatting changes.
Y - axis Values: Off
Line Interpolation type: Smooth
Shade area: On
Match line color: Off
Color: Your choice
Markers: On
Shape type: Your choice
Color: Your choice
Data labels: On
Background: On
Color: Your choice
Transparency: 40% approx
Your chart should look something like this.
Nobody wants to do planks!
Rename the page Line Chart and then duplicate the page.
Rename the duplicated page as Monthly.
With your chart selected, add Month from the Class Date Hierarchy to the Small multiples bucket.
Make the following formatting changes.
Small multiples
Layout: 3 Columns
Title Position: Bottom
Title Alignment: Centre
You should now see something like this.
So much easier than creating 12 separate charts!
Save the file as Line charts are great.pbix
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.