Power BI Desktop - Excelerator BI

Power BI Desktop

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

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

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

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

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

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

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

Query By Example YYYY-MM

Query by Example to Extract YYYY-MM from a Date Column

I was answering a question for a student in one of my online training courses this week. The question was, “Do you know of a way in power query to efficiently extract YYYY-MM from a …

Query by Example to Extract YYYY-MM from a Date Column Read More

Copy measures between PBIX files

Copy Measures Between 2 Power BI Files

I have often been asked (and wondered myself) if it were possible to move all the measures from one Power BI PBIX file into another.  Imagine you have 2 PBIX files with similar data models …

Copy Measures Between 2 Power BI Files Read More

Power BI Desktop Release Date History – Using Power BI

I was chatting to a few of my Power BI buddies during the week about when we thought the December 2018 update would be released.  It seemed to me that under normal circumstances the new …

Power BI Desktop Release Date History – Using 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

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

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

Data Profiling in Power BI

Today Microsoft released the October 2018 update of Power BI Desktop.  One of the fabulous new features that has been released is the ability to get a visual profile of your data in Power Query …

Data Profiling in Power BI Read More

Scroll to Top