Power BI video shorts | Drill using inactive relationship
Posted by Sam Lowrie on 12 October 2021
Sometimes you want to connect tables using more than one join. This is fine when performing a DAX calculation but what about drilling? In this short Sam covers how to use an inactive relationship to filter the data when drilling.
Duration: 7 minutes and 4 seconds.
Click on the Files tab above to see (and download) the 2 files that go with this short.
You can use the Help tab above to get the most out of watching this short.
This short has the following accompanying files:
|14 Drillthrough using a different relationship (Complete).pbix||Power BI report|
|14 Drillthrough using a different relationship.pbix||Power BI report|
Click to download a zipped copy of the above files.
Making a video bigger
You can increase the size of your video to make it fill the screen like this:
Play your video (the icons shown won't appear until you do), then click on the full screen icon which appears as shown at its bottom right-hand corner.
When you've finished viewing a video in full screen mode, just press the Esc key to return to normal view.
Improving the quality of a video
To improve the quality of a video, first click on the Settings icon:
Make sure you're playing your video so that the icons shown appear, then click on this gear icon at the bottom right-hand corner.
Choose to change the video quality:
Click on Quality as shown to bring up the submenu.
The higher the number you choose, the better will be your video quality (but the slower the connection speed):
Don't choose the HD option unless you have a fast enough connection speed to support it!
Is your Wise Owl speaking too slowly (or too quickly)? You can also use the Settings menu above to change your playback speed.