Blog - Excelerator BI
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

Icons

Conditional Formatting Using Icons In Power BI

Today Microsoft announced that it is now supporting icon sets to be used for conditional formatting in Power BI.  This feature has been available in Excel, like forever, and it great to see it available …

Conditional Formatting Using Icons In Power BI Read More

Final Chart 2

Pareto Analysis in Power BI

Level: Intermediate Pareto Analysis is a statistical technique that applies the Pareto Principle to data. This is more commonly known as the 80:20 Rule. The Pareto Principle is based on the presumption that a relatively …

Pareto Analysis in Power BI Read More

Slicerwithhistogram

Slicer with Histogram in Power BI

I was doing some online shopping last week and saw a price slicer with a histogram to show the concentration of price points.  I thought it was pretty cool, so decided to see if I …

Slicer with Histogram in Power BI Read More

Filters on Power BI Slicers – Wait, What?

There was a new feature released in the June 2019 version of Power BI Desktop that I really like and I think warrants some explanation and review.  The new feature allows you to pre-filter a …

Filters on Power BI Slicers – Wait, What? Read More

Power BI APIs for Non-Programmers

Level: Intermediate There was an announcement made a few weeks ago by Microsoft that nearly slipped under my radar.  I don’t always read the more technical announcements because I don’t have a highly technical background.  …

Power BI APIs for Non-Programmers Read More

Solving a Complex Time Problem In Power BI

Level: Intermediate I was delivering some training last week for a customer in Sydney and they participants had an interesting problem where they needed to be able to report on a rolling time window.  Think …

Solving a Complex Time Problem In Power BI Read More

Pivoting Text Data Using Power Query

It is very common to need to transform data from one “shape” to another “shape” before it can be used inside Power BI for analysis (although many beginners don’t realise this).   One such example is …

Pivoting Text Data Using Power Query 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

Measure Tables in Power BI

I often get asked about measure tables during my Power BI online training classes. This post will discuss the merits of measure tables versus storing your measures in the table where the data comes from. …

Measure Tables in Power BI Read More

Expanding Rows Using Power Query

I had an interesting question from one of my book readers and I thought it would make a good blog article. There are many ways of solving this problem, and I blogged about solving a …

Expanding Rows Using Power Query Read More

Grouping in Power BI Desktop Without Using DAX

Way back in Oct-2016, Microsoft released a feature in Power BI Desktop that makes the process of creating groups much easier for the average user. I was reminded of this feature by an article by …

Grouping in Power BI Desktop Without Using DAX 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

Reposition Report Canvas in Power BI Desktop

Just a short post today to share with you a permanent fix to something that has been annoying me (maybe you too – but then again I am easily annoyed 🙂 ).  Edit:  read the …

Reposition Report Canvas in Power BI Desktop Read More

Scale your Power BI Capacity Up/Down

This is the third article in my series about how to make Power BI Premium more affordable for small to medium sized enterprises (SMEs).  In my first article I explained the problem and the logic …

Scale your Power BI Capacity Up/Down 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

Scroll to Top