POWER BI video shorts

We have 22 Power BI shorts listed below.

Using Emoji in Power BI Reports

Posted by Sam Lowrie on 07 May 2021

We use Emoji almost everyday, but what about in our reports? This video covers the inclusion of Emoji and ideas how to use them.

5 Reasons to use Power BI Templates

Posted by Sam Lowrie on 06 July 2021

If you have been on one of Sam's courses you will know his love of templates. In this short explore the top 5 reasons why you should love templates to!

Power Query functions

Posted by Sam Lowrie on 14 July 2021

Functions can be incredibly helpful when an action needs to be performed for a list of items. In this example we create a function to scrape data from multiple pages on a website.

Export data using Power Automate

Posted by Sam Lowrie on 26 July 2021

Exporting data via Export on a visual can be cumbersome and limits what can be done with the data. The Power Automate visual lets you create action flows triggered by a button in Power BI. In this video learn how to capture data in PowerBI and export to an Excel file.

Write and present manager comments in Power BI

Posted by Sam Lowrie on 26 July 2021

The built in comments system is great but it doesn't have a huge scope. Using Power Apps we can write, record and present comments in real time.

Dynamic Maximum Y Axis

Posted by Sam Lowrie on 03 August 2021

Sam has been looking forward to this feature for literal years! Finally the Y-axis minimum and maximum can be set based on an expression. Learn how to let the user choose the maximum on the Y-axis but also set the maximum to the highest unfiltered value in the visual.

More report space - Power BI

Posted by Sam Lowrie on 10 August 2021

Power BI is great but sometimes the space can feel like such a limiting factor. In this video learn three different techniques to make the most of the space you have.

Dynamic Y Axis (Swapping KPIs) - Power BI

Posted by Sam Lowrie on 24 August 2021

User can already interact with Power BI visuals, changing filters and drilling between levels within the data. What it doesn't let you do automatically is swap which KPI is displayed. Learn how to do this with a slicer and sneaky measure.

Calculate and ALL (Removing filters with DAX)

Posted by Sam Lowrie on 24 August 2021

Start learning the weird and wonderful ways of DAX with this short tutorial. Add and remove filters using the CALCULATE function with ALL.

Alternate uses for Treemaps

Posted by Sam Lowrie on 12 October 2021

Treemaps are one of the best ways to interact with a report, colourful buttons for the front end uses. Have you ever considered using them as variance bars or wanted the same size but different figures? In this short Sam shows you how.

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.

Download email attachments

Posted by Sam Lowrie on 12 October 2021

Power Automate can take the repetition out of mundane tasks and without knowing any code! Sam had a bunch of emails with attachments and didn't want to manually download them. In this short learn how to automatically download all the attachments from a bunch of emails.

Import custom fonts

Posted by Sam Lowrie on 21 October 2021

One of the stranger missing options in Power BI is the ability to import custom fonts. Sam wanted to spice up this report with an old classic font and found the way to do it was with JSON and it was easy!

Using Calculation Groups

Posted by Sam Lowrie on 21 October 2021

When creating measures often the time aspect is repeated for each one. Make a measure, then make the YTD and PY versions. There must be a better way! In this episode Sam learns about Calculation groups and how they can reduce the word load! Link to SQLBI: https://www.sqlbi.com/tools/

Automation with Power Automate

Posted by Sam Lowrie on 26 October 2021

If you haven't sampled the uses of Power Automate then you are missing out. A basic packaged is included with all Office 365 licences meaning you probably have access! Follow along as Sam takes a table of Excel information and turns that into a series of teams meetings for multiple different people.

Creating your first Power App

Posted by Sam Lowrie on 08 November 2021

Power Apps can be used to create mobile, tablet or web applications for your company. It requires no coding knowledge and a baseline level of Excel expressions. In this episode Sam creates a basic app by uploading data, creating a gallery and then writing changes back to the data.

Using the Mapbox visual in Power BI

Posted by Sam Lowrie on 08 November 2021

Recently a delegate had the audacity of questioning if there was a better option than the built in map. Naturally for their crimes they were removed from the course however that got Sam thinking... In this short Sam shows how to use the Mapbox visual as a choropleth or filled map. Specifically for UK regions and local authorities but the process is the same for everywhere.

Revert column formatting

Posted by Sam Lowrie on 22 November 2021

Ever noticed that conditionally formatted columns always remove all the formatting. Even on rows that don't need formatted get overwritten. In this Short, Sam shows you how to revert to your previous formatting on non formatted rows.

Dynamic role access

Posted by Sam Lowrie on 13 December 2021

Power BI role level security is a great thing but by default it doesn't change based on the logged in email. What if you could? In this short Sam shows you how to detect the email address and determine the users role. Then using the role, filter the client table to only clients that role allows access to!

Files and Folders

Posted by Sam Lowrie on 04 January 2022

Quickly find, sort and reorder your documents. Power Automate is included within most Office licences.

Suppress rows in Power BI Visuals

Posted by Sam Lowrie on 17 February 2022

Sometimes you have unwanted rows in your visuals. In this short Sam uses DAX to either replace the unwanted value with an * or hide it entirely.

A high-level comparison of how to do common tasks in Tableau and Power BI

Posted by Andy Brown on 07 June 2022

There are two big beasts in the Business Intelligence jungle: Microsoft's Power BI and Salesforce's Tableau. Wise Owl run training courses in the first, and Viz DJ in the second. But what happens when these beasts meet each other?

You might also like to consider booking a place on one of our online or classroom Power BI courses, where you will meet the owls behind the video shorts!

This page has 0 threads Add post