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 | Power BI Dynamic connection string
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 if you attend one of more of the courses 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.
In the above folder are 3 Excel files containing information about the tallest buildings in various countries. The aim is to be able to switch between viewing the top 10 from each file by changing to which file we are connecting:
To start with either connect to the UK file from scratch, or else open the PBIX file in the above folder.
We need to store the location of each file in a parameter so we can switch between them. To do this, create a parameter and list the file names:
This will create a drop down letting users choose which file to connect to.
Now access the Advanced Editor from the Home tab within Query Editor and replace the file name with your parameter:
The & is used to concatenate the string connection with the value inside the parameter.
Exit Query Editor and then use Edit Parameters under Edit Queries to switch to a different file:
You may need to click Apply changes to finish loading the data.
Optionally save this as Tall, Taller, Tallest and then close it down.