Archive - Blog Posts on How to

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 slicer so that it only contains a subset of values that would otherwise appear in that slicer. Filters on Non-Slicer […] Read More
Power BI APIs for Non-Programmers - 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 very useful for anyone with […] Read More
Solving a Complex Time Problem In Power BI - 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 of it a bit like Rolling 12 Months Sales, or average weekly sales over a rolling 4 week period, but […] Read More
Pivoting Text Data Using Power Query - 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 shown below, where the data in the table on the left hand side needs to be transformed into the table […] 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 may choose not to use a measure table. I also mentioned some alternatives to using measure tables, including using a […] Read More
Six Sigma Control Charts in Power BI - 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 be a Six Sigma black belt, but I do know how to write DAX and I do know how to […] 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. What is a Measure Table? A measure table is a dedicated table used to store some or all of the […] Read More
Expanding Rows Using Power Query - 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 this blog post is using […] 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 Reid Havens a couple of months ago. I blogged about various other ways of doing this, including banded columns using DAX […] Read More
Show or Hide a Power BI Visual Based on Selection - 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 appear (or not) based on a selection from the user.  There is no out of the box way to do […] 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 comments below from Amir Netz from Microsoft where he explains why this change was made Vertically Position Report Canvas in […] Read More
Scale your Power BI Capacity Up/Down - 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 behind how to configure a workable solution. In my second article I provided step by step instructions on how to […] Read More
Affordable Power BI Premium for Small Business (Part 2) - 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 for small to medium sized enterprises (SMEs).  You can read the first article in this series from the following link: Affordable […] Read More
Affordable Power BI Premium for Small Business (Part 1) - 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 suitable scalable Power BI pricing model for small to medium sized enterprises (SMEs).  You can read my rant about that […] Read More
Conditional Formatting with a Text Field in Power BI - 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 it could be done, but […] Read More
Find and Delete Duplicate Photos with Power Query - 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 great software and you can download it here).  After running the software I noticed that I had stored photos from […] Read More
Extract Numerical Data Points from an Image - Today Gartner released the 2019 magic quadrant for Business Intelligence.  As expected (by me at least), Microsoft is continuing its trail blazing and now has a clear lead over Tableau in both ability to execute and completeness of vision.  I thought it would be interesting to see a trend over time for the last 5 […] 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 (similar enough that the measures will be substantially the same).  It doesn’t matter how you got to this point – […] 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 then, significantly: What implication is there to the Power BI Golden Dataset as a result of the new dataflows? Should I […] Read More
Create a Planning View of Your Outlook Diary in Power BI - I was chatting to my wife the other day discussing all the things we want to do next year. It has long been a pain in the butt to get a high level (big picture) view of your Outlook diary to see what is happening (think forest, not trees).  In the past I have used […] Read More