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 …
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 …
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 …
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 …
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. …
Level: Intermediate I was delivering some training last week for a customer in Sydney and they participants had an interesting problem where they needed to be able to report on a rolling time window. Think …
It is very common to need to transform data from one “shape” to another “shape” before it can be used inside Power BI for analysis (although many beginners don’t realise this). One such example is …
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
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 Chart. Now I am not professing to …
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. …
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 …
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 …
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 …
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 …
This is the third article in my series about how to make Power BI Premium more affordable for small to medium sized enterprises (SMEs). In my first article I explained the problem and the logic …
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 …
Level: Advanced This is the second in my series of articles explaining how to use Microsoft Flow, the Azure APIs, the Power BI APIs and SharePoint Online to help make Power BI Premium more affordable …
Affordable Power BI Premium for Small Business (Part 2) Read More
Level: Advanced This is another one of those articles that has been swirling in my head for a very long time, about 2 years actually. I have long been frustrated by the lack of a …
Affordable Power BI Premium for Small Business (Part 1) Read More
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
I was trying to clean up my hard disk drive on my PC the other day. I use a program called WinDirStat to show me graphically what is taking space (as an aside, this is …
Matt shares lots of free content on this website every week. Subscribe to the newsletter and you will receive an update whenever a new article is posted.
Excelerator BI | Expert Power BI Training | © 2019
