WISE OWL EXERCISES
POWER BI EXERCISES
POWER BI EXERCISES
- Basic reports (10)
- Data sources (2)
- Query editor (8)
- Multiple tables (1)
- Filtering data (9)
- Drill-through filtering (1)
- Bookmarks (4)
- Charts (10)
- Other types of visualisation (1)
- Overview of maps (6)
- Calculated columns (7)
- Introduction to DAX (3)
- Creating measures in DAX (1)
- Calendars (2)
- Date functions (2)
- Roles and security (1)
- Advanced data models (4)
- Drill-through and bookmarks (3)
- Custom visuals (3)
- Parameters (5)
- Quick measures (3)
- Report themes (2)
- Power BI mobile (1)
- Power BI Templates (1)
- Tooltips (2)
Power BI | Parameters exercise | Filter data models using drop down parameters
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.
You can learn how to do this exercise on the relevant Wise Owl classroom training course (sadly for the moment only in the UK).
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.
Rather than give an input box for parameters we instead want to create a drop down for filtering. Like this in fact:
Choosing a treatment will filter the data brought through into the data model.
Load the data from the Excel sheet in the above folder. Before we create the parameter we first need to create the drop down list for it. Right-click the Usual Treatment column:
At the bottom of the list choose Add as New Query.
Now remove any duplicates from your list of usual treatments, and sort it:
This list will contain each value multiple times, so right-click on it and choose Remove Duplicates (then sort the items into ascending order, as here).
You now have a query to use for populating a drop down. Create your parameter:
Irritatingly you still must choose an initial Current Value (and even more annoyingly it doesn't even give you the drop down you made to help you choose!).
Filter your data to show only customers who have had the specified treatment:
Only show treatments which match the one set as the parameter value.
Try flicking between the different treatments using Edit Queries then Edit Parameters from the Home tab, to test that everything works, then save your report as Dropping usual treatments.