I stumbled across an interesting problem recently when helping someone on a forum. Here is the scenario. Assume there is a help desk that is logging tickets into a system. Each ticket is assigned to single staff member who is responsible to action that ticket. The requirement is that when […]
I have been planning for various speaking and training events over the last 6 months and these events are now rapidly approaching. As it turns out, it seems I have a bit of a world tour planned and so I wanted to share these plans with you in the hope […]
Last week I held a free Power BI webinar for people starting out with Power BI who are wondering why they should invest time in learning about DAX. I had more than 700 people register and was completely overwhelmed by the response. There were a few questions that I didn’t […]
Recently Microsoft introduced the DAX REMOVEFILTERS() new function. This is a very useful and well named function and it does exactly what its name suggests. Its purpose is to act as a table filter parameter inside CALCULATE() as shown in the following example. Total Sales All Products REMOVEFILTERS() = CALCULATE([Total […]
I was delivering Power BI training in Melbourne last week and one of my students asked if it was possible to show on a report if any filters have been applied. It is a very good question because it is not always immediately obvious if filters have been applied or […]
UPDATE: Below is a registration link for access to the Webinar. On 2 October I will be hosting a free webinar called “Introduction to DAX for Power BI”. I have trained literally thousands of people on the DAX language through my books, online training and live training. But everyone is […]
In this article I am going to share with you a concept to manage refresh failures in production PowerBI.com reports. In a perfect world, you should configure your queries so that they “prevent” possible refresh failure issues from occurring, but also to notify you when something goes wrong without the […]
There are some valid reasons why you may need to change the names of all the columns in a table for use in Power BI. It is of course possible to change each column name by editing it manually, but what I am going to show you today is changing […]
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 on a daily basis, but some of your reporting is done on a monthly basis. […]
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 will explain the basics of using the FILTER() function in DAX. Make sure you then […]
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 now in Power BI. Set Up Power BI Conditional Formatting Using Icons I have a […]
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 small number of inputs (20%) have most impact on the results/output (80%). The 80:20 rule […]
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 could build this in Power BI. I came up with a solution that works, and […]
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 slicer so that it only contains a subset of values that would otherwise appear in […]
Updated: 17 Jan 2020. Updated: 22 Sep 2021. Updated: 27 Apr 2022 – Walkthrough Video Added Background This is the 3rd iteration of this Power BI Visual Based on Selection article, attempting to address some of the confusion that has emerged since I added the [Check Filtered] measure into the […]
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 how to apply conditional formatting with a Text field (not a numeric field). I knew […]
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 of blogs already that talk about the announcement, including Chris Webb and The Italians, but […]
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 been faster than it is today. The market is changing so quickly that many Business […]
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 the background and his report. Neville: Keeping track of Power BI Desktop’s amazing features since […]
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 a folder with Power Query. Load the Latest Version of a File with Power Query. […]
Excelerator BI | © 2025 | Sitemap