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
547 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 ==> | DAX (59 exercises) |
Topic ==> | The CALCULATE function (16 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 Music Tours - Calculate Keep Filters.pbix file in the folder shown above. On Page 1 you should see a bar chart displaying the average peak chart position for albums by different artists.
The chart currently shows all artists.
Create a measure which shows the average peak chart position for any three artists of your choice. Replace the current measure in the chart with your new measure.
Your selection can be as eclectic as you like - we selected names that are short and easy to spell!
Create another measure which shows the average peak chart position and which excludes any three artists of your choice. Create a new bar chart to display this measure along with the Artist field.
This chart appears to lack direction.
On Page 2 of the report you will find a line chart showing the percentage of cancelled shows per year.
The chart contains a single series.
We'd like to divide the line on the chart into three sections based on the [Show date].[Year] column:
Section | Years to include |
---|---|
Pre-COVID | Up to and including 2020 . |
During COVID | 2020 to 2022 inclusive. |
Post-COVID | 2022 or later. |
Create three measures to show these values and place them in the line chart (you can remove the original measure when you do this). Apply formatting to the lines for the three series so that your chart resembles the one shown below:
The COVID years should be easier to spot after applying some formatting.
Save and close the report.
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.