Dual Axis Line Chart in Power BI
As most readers of my website would surely know, Microsoft Excel has had a dual axis line chart as a standard charting visual for many many (many) years. A dual axis line chart is needed …
Extracting Data from Complex Web Pages with Power BI
Back in 2018 I wrote an article showing how to extract data from websites using Power Query in Excel. For simple websites this process is very straightforward. For more complex websites the process is not …
Extracting Data from Complex Web Pages with Power BI Read More
I’m Hiring A Power BI Trainer/Consultant
Edit: 27th Nov 2019. Note applications for this job are now closed. It is 5.5 years since I left my 25 year corporate role at Coca-Cola and started my own business training and supporting the …
Microsoft Renames Flow to Power Automate
Last week in Orlando Florida, Microsoft held its annual Ignite conference. I have never been to Ignite but it is on my list of things to do in the future. There are always lots of …
Show the Tickets Assigned to Me (or Others)
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 …
Combining Multiple Sheets from Multiple Workbooks
I have written a series of articles where I explained different methods of combining data from multiple files into a single workbook/table using Power Query. In the first article, I explained how to create a …
Matt’s Power BI World Tour
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 …
Power BI Webinar Overflow Q&A
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 …
REMOVEFILTERS() in DAX
Level: Intermediate Recently Microsoft introduced a new function in DAX called REMOVEFILTERS(). This is a very useful and well named function and it does exactly what its name suggests. Its purpose is to act as …
Is my Power BI Report Filtered?
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 …
Free Webinar: Introduction to DAX for Power BI
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 …
Preventing & Managing Refresh Failures in Power BI
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 …
Preventing & Managing Refresh Failures in Power BI Read More
Renaming all the Columns in a Table at Once using Power Query (M Language)
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 …
Renaming all the Columns in a Table at Once using Power Query (M Language) Read More
Use Microsoft Flow to Notify of New Files in a Folder
Last week I attended Summit Australia in Melbourne. Summit Australia is a conference that focuses on the same products as the larger Microsoft Business Applications Summit (held this year in Atlanta). The majority of delegates …
Use Microsoft Flow to Notify of New Files in a Folder Read More
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 …
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 …
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
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 …
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 …
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 …