Blog • Page 7 of 24 • My Online Training Hub

April 29, 2021

Highlighting Data in Power BI Visuals

In this post I'll be looking at ways to highlight or label values that may be of special interest in

April 27, 2021

Secrets to Building Excel Dashboards in Under 15 Minutes

Building Excel Dashboards doesn't need to be a slow process. When your data is structured correctly you can use the

April 21, 2021

Power BI Organizational Data Types in Excel

UPDATE: Organization Data Types will be retired in Microsoft Excel effective July 31, 2025. Instead, we recommend customers switch to

April 15, 2021

Shape Maps in Power BI

In this post I'm going to show you how to use Shape Maps in Power BI, which are currently a

April 7, 2021

Excel Workbook Protection

When you spend days crafting your latest report, the last thing you need are well meaning users messing with your

March 31, 2021

Static Tables in Power Query, Power Pivot and Power BI

Ordinarily when you want to create a table in Power Query, Power Pivot or PBI, you'd write a query to

March 25, 2021

Change Type Using Locale with Power Query

One of the most common issues I help people fix is data imported to Excel or Power BI using Power

March 18, 2021

Get Data from OneDrive or SharePoint with Power Query

Nowadays many of us are saving our files to the cloud using OneDrive for Business or SharePoint Online. Unfortunately, it’s

March 11, 2021

Converting Decimal Time to Days, Hours, Minutes, Seconds in Power BI

When you deal with elapsed time in Power Query you can make use of the Duration data type. Howevere when

March 4, 2021

Recursive LAMBDA Functions

The new Excel LAMBDA function that we looked at last week also enables us to write custom recursive LAMBDA functions.

February 25, 2021

Excel LAMBDA Function

The new Excel LAMBDA function allows you to define your own custom functions using Excel’s familiar formula language. That means

February 18, 2021

Sort-By Columns in Power BI

Normal sorting behaviour is to sort based on a numeric value, either higher to lower or lower to higher. But

February 11, 2021

Excel Pyramid Charts

Excel pyramid charts are easy to build using bar charts or Conditional Formatting, but there are a few rules you

February 4, 2021

Personal Stock Portfolio Dashboard

Keeping track of your share trading is easy with this personal stock portfolio dashboard. It uses the latest Excel tools*

January 28, 2021

Custom Formatting Strings in Power BI

You may be familiar with Custom Format Strings in Excel, if you are not then check this Excel Custom Number

January 21, 2021

Highlighting Periods in Excel Charts

Shading or highlighting periods in Excel charts can help users more quickly interpret them and identify patterns. In the chart

January 14, 2021

Table Statistics from Table.Profile in Power Query

It's often useful to know some quick statistics about our data. Things like the minimum or maximum values, or the

changing power query data source settings

December 16, 2020

Changing Data Source Location in Power Query

Here's the scenario - you've created a query in Power Query that loads data from a source, either a file

December 10, 2020

Stacked Bar Excel Waffle Charts

Last week we looked at building Excel waffle charts using Conditional Formatting. This week we’re looking at building Stacked Bar

December 3, 2020

Excel Waffle Charts with Conditional Formatting

Excel Waffle Charts are a popular way to visually display parts to a whole. You can think of them as

November 24, 2020

Dense Ranking in Power Query

There are several ways to rank things, dense ranking is when items that compare equally receive the same ranking number,

November 19, 2020

Force Excel Slicers to Single Select

There’s no built-in way we can force Excel Slicers to single select, but we can use some crafty tricks to

November 10, 2020

Excel Dashboards vs Power BI Dashboards

One of the most common questions I get is: Should I be using Power BI to build dashboards instead of

November 3, 2020

How to Build Power BI Dashboards

Demand for data visualisation skills is showing no signs of slowing. There are many BI tools available, and this can

October 29, 2020

Create a List of Matching Words When Searching Text in Power Query

My previous post searched for text in columns and returned a true/false result if a match was found. This post

October 22, 2020

Searching for Text Strings in Power Query

Let's say we have a column of text and we want to search it to see if each row contains

October 15, 2020

Introduction to Power Query

What’s the big deal about Power Query? Talk to those who have used it and they’ll tell you how amazing

October 7, 2020

Grouped Running Totals in Power Query

In a previous post I looked at creating running totals in Power Query, here I'll be creating grouped running totals.

October 1, 2020

Power Query Custom Data Types

You may already be familiar with Excel Data Types for geography and stocks, but with Power Query Custom Data types

September 24, 2020

Quickly Create Running Totals in Power Query

A running total (or cumulative sum) is when you add the previous value to the next, basically you're summing values