Posted inData & Analysis

Slicer with Histogram in Power BI

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…
Posted inData & Analysis

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…
Posted inData & Analysis

Power BI APIs for Non-Programmers

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…
Posted inData & Analysis

Solving a Complex Time Problem In Power BI

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…
Posted inData & Analysis

Six Sigma Control Charts in Power BI

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…