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 (3)
- Charts (10)
- Other types of visualisation (1)
- Overview of maps (5)
- 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)
- BI mobile (1)
- Power BI Templates (1)
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.
The answer to the exercise will be included and explained if you attend the course listed below!
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 need to create the drop down list. Right-click Usual Treatment column:
At the bottom of the list choose Add as New Query.
By creating a separate query based on the original query we ensure that the drop down values will be the same as those in the original column.
This list will contain each value multiple times, so it's worth right clicking and choosing Remove Duplicates.
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!).
Try flicking between the different treatments using Edit Queries then Edit Parameters from the Home tab. Save as Dropping usual treatments.