Power BI - Excelerator BI

Power 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

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

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

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

Calculation Groups are Coming to DAX

I woke up Saturday morning to a lot of chatter and blog articles about an announcement that Microsoft made at SQL Bits.  Microsoft is adding “Calculation Groups” to the DAX language. There are a number …

Calculation Groups are Coming to DAX 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

Power BI Features Reporting

Power BI Features Reporting

Matt here.  The blog article this week was written by Neville de Sousa.  Neville shared with me a Power BI report that shows all the Power BI features released since July 2015.  Neville will explain …

Power BI Features Reporting Read More

calendar overrun in Power BI

Calendar Over Run While Comparing Last Year’s Data

Recently, I was helping someone on Power BI community forum on the issue of calendar over run while comparing values with last year’s data. I thought it would make a good article to share with others. …

Calendar Over Run While Comparing Last Year’s Data Read More

Import First Sheet with Power Query

Import the First Sheet in a Workbook with Power Query

My series about common patterns for loading data using Power Query received quite a lot of interest over the last few weeks.  You can review those articles in the links below Combine all files in …

Import the First Sheet in a Workbook with Power Query Read More

Combine All Sheets in a Workbook with Power Query

There are quite a few different common business scenarios where you get data in the form of a file on a regular basis.  The 3 common patterns I use most often are. Each day/month/year you …

Combine All Sheets in a Workbook with Power Query Read More

Best Book for Learning the M Language

Late in 2018 there was a new Power Query book written by Gil Raviv called Collect, Combine and Transform Data Using Power Query in Excel and Power BI.  That’s a bit of a mouthful actually; …

Best Book for Learning the M Language Read More

Load latest file in Power BI

Load the Latest Version of a File with Power Query

There are quite a few common business scenarios where you get data in the form of a file on a regular basis from some source system and you need to process these files into your …

Load the Latest Version of a File with Power Query Read More

Rename Blank in a Slicer in Power BI

A common problem I see some people struggle with in Power BI is when a slicer contains a (Blank) record for some reason.  The cause of the problem is not obvious and hence it is …

Rename Blank in a Slicer in Power BI Read More

Importing XLSB into Power BI

I had a question from one of my online Power BI Training students just this week who was struggling to import data from a large *.xlsb Excel file.  I suggested she save the file as …

Importing XLSB into Power BI Read More

Moving Queries from Power BI Desktop to Dataflows

A few weeks ago I wrote an article introducing dataflows in Power BI and discussed why you should care about them.  There are a few questions that have been spinning around in my head since …

Moving Queries from Power BI Desktop to Dataflows 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

Scroll to Top