Learning Resource - Excelerator BI

Learning Resource

081019 0301 Dynamically1.png

Dynamically Show Completed Months in Power BI

One common requirement I have come across a few times is to limit a Power BI visual to only show completed months and exclude the current active month. This is common if you load data …

Dynamically Show Completed Months in Power BI Read More

List of all standard Power BI Icons

Power BI Icon Names

A few weeks ago I wrote an article “Conditional Formatting Using Icons In Power BI” about the Power BI Icon feature released in July 2019. There were 2 common questions/themes coming from readers’ comments, and …

Power BI Icon Names Read More

Large Customer Sales

The FILTER Function in DAX Part 2

Level: Intermediate In my last article, I introduced the basics of the DAX FILTER() function. Hopefully that introductory explanation to FILTER() helped you get your head around what FILTER() is doing under the hood. With …

The FILTER Function in DAX Part 2 Read More

072419 0359 Thefilterfu2.png

The FILTER Function in DAX

Level: Intermediate FILTER() is one of the most important functions in the DAX language. It is quite a simple function and yet many people are scared off when they see it. In this article I …

The FILTER Function in DAX Read More

Column Sub Folders are Better than Measure Sub Folders

I blogged about the various ways to use Measure tables and Measure Sub Folders in Power BI a few weeks back.  I discussed why measure tables may be required, and also a few reasons why you …

Column Sub Folders are Better than Measure Sub Folders Read More

Six Sigma Control Charts in Power BI

Level: Intermediate I have had a couple of requests for help during my live training classes and online training classes on how to build a Six Sigma Control Chart.  Now I am not professing to …

Six Sigma Control Charts in Power BI Read More

Show or Hide a Power BI Visual Based on Selection

I have written a few articles in the past that toy with the ideas of changing visibility and text colour based on selection.  I started to wonder if it was possible to make a visual …

Show or Hide a Power BI Visual Based on Selection Read More

Simple Filters and Syntax Sugar in DAX

Level: Intermediate There is a concept in the DAX language called “Syntax Sugar”.  Simply put, the developers have created simplified versions of more complex formulas to make it easier for people to learn and use …

Simple Filters and Syntax Sugar in DAX Read More

Affordable Power BI Premium for Small Business (Part 2)

Level: Advanced This is the second in my series of articles explaining how to use Microsoft Flow, the Azure APIs, the Power BI APIs and SharePoint Online to help make Power BI Premium more affordable …

Affordable Power BI Premium for Small Business (Part 2) Read More

Affordable Power BI Premium for Small Business (Part 1)

Level: Advanced This is another one of those articles that has been swirling in my head for a very long time, about 2 years actually.  I have long been frustrated by the lack of a …

Affordable Power BI Premium for Small Business (Part 1) Read More

Conditional Formatting with a Text Field in Power BI

One of the things I like about my live, online training courses is that I get to hear great questions from the trenches from people learning DAX and Power BI.  Last week, John asked me …

Conditional Formatting with a Text Field in Power BI Read More

What is the Best Training for Business Analysts?

Updated Feb 2019.  This is an edited version of my original article which first appeared on my site in Feb 2016. The rate of change in the tools available to a Business Analyst has never …

What is the Best Training for Business Analysts? Read More

Extract Numerical Data Points from an Image

Today Gartner released the 2019 magic quadrant for Business Intelligence.  As expected (by me at least), Microsoft is continuing its trail blazing and now has a clear lead over Tableau in both ability to execute …

Extract Numerical Data Points from an Image Read More

Create a Planning View of Your Outlook Diary in Power BI

I was chatting to my wife the other day discussing all the things we want to do next year. It has long been a pain in the butt to get a high level (big picture) …

Create a Planning View of Your Outlook Diary in Power BI Read More

Power BI Dataflows, and Why You Should Care

Microsoft recently released a new feature in Power BI called “Dataflows”.  You may have seen it pop up in a recent release of Power BI Desktop under Home\Get Data\Power BI Dataflows (beta) as shown below. …

Power BI Dataflows, and Why You Should Care Read More

Power BI Training

Power BI is an Enigma, so What to Do?

Power BI is an enigma.  On the surface Power BI is an alluring product that promises to change your world of data analytics for the better – and indeed it can and will.  But sitting …

Power BI is an Enigma, so What to Do? Read More

When to Use SUM() vs SUMX()

Level: Beginners/Intermediate (Updated Oct 2018). This is a further (third) update/edit to an article I first wrote 3 years back and then updated a year back.  When I update my articles I simply change the …

When to Use SUM() vs SUMX() Read More

Create a Power BI Slicer Panel

There is nothing worse than having a Power BI report that has 50% of the space taken up with slicers.  When this happens, you only get half the page to visualise the actual data.  But …

Create a Power BI Slicer Panel Read More

Visually Appealing Power BI Reports

One thing I often get asked is “How do I create good looking Power BI Reports?”.  This is a very good question and unfortunately the answer is not straight forward.  I like to think of …

Visually Appealing Power BI Reports Read More

Using Variables to Write Measures

It’s pretty early in the morning here in Sydney Australia (just after 6 am actually).  I just finished a fun YouTube session with Avi Singh where I demonstrated my approach to using variables in DAX …

Using Variables to Write Measures Read More

Scroll to Top