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 […]
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 […]
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 that knowledge in place, let me help you take your understanding to the next level. […]
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 […]
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 […]
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. Luckily I read this particular announcement as it contained a nugget of gold that is […]
Level: Intermediate I was delivering some training last week for a customer in Sydney and the participants had an interesting problem where they needed to be able to report on a rolling time window. Think of it a bit like Rolling 12 Months Sales, or average weekly sales over a […]
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 Charts in Power BI. Now I am not professing to be a Six Sigma black belt, but I do know how […]
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 similar problem Fill Table with Last Survey Result using DAX here. The solution I am providing in […]
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 the DAX functions. Here are a couple of examples. Total Sales Syntax Sugar = SUM(Sales[ExtendedAmount]) […]
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. […]
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 get a new file containing incremental data. All the data in all the files need […]
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 Power BI reports. There are 3 common patterns that come to mind. Each day/month/year you […]
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 not clear how to fix it. This article describes what causes this to occur and […]
Note: This is copied onto the original Post – How and Where to Get Help for Power BI Level: Beginners/Intermediate Regardless of what stage you are at in your Power BI/Power Pivot/Power Query journey, at some stage you are going to need some help. Believe me I am no different to […]
Level: Beginners/Intermediate (originally posted 2015, updated 2017, 2018, 2022). This article is one of the most frequently read on my blog site and I wanted to update it to continue to improve the value people get from my site. Even if you have read this article before, why not take […]
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 on the flip side, if you don’t have the slicers it can be harder for […]
I was in Seattle, USA in the last week of July participating in the Microsoft Business Applications Summit (MBAS). I love attending conferences like this and it was a privilege to present on a few topics over 3 days. Evaluation contexts in Power BI DAX One of the presentations I gave […]
Excelerator BI | © 2023 | Sitemap