Just a quick blog post so that other people don’t waste 15 minutes of their life looking for a missing checkbox. I was implementing security using roles in a Power BI Desktop model. I had defined the role along with its filter on top of a many 2 many relationship. The relationship between the fact […]
Tag: power bi
Dynamically Changing Shapes in Power BI – Alternatives
NOTE: the DAX presented in this blog post is written in my locale (nl-BE). This means that semicolons are used in the functions and lists instead of commas. Also, we use the comma as the decimal seperator. 0.95 (in the US) is 0,95 in my locale. A couple of well placed search and replaces should […]
Dynamically Changing Shapes in Power BI
UPDATE: I also published a blog post using a DAX only approach. Check it out here. Recently someone had a question if it was possible to change the color of a shape depending on the value of a measure. Imagine for example a dashboard with the picture of a database server. If up-time is good […]
Speaking at Techorama 2017
I’m delighted to announce that I’m selected as a speaker for the Techorama event. Techorama is a developer congress focusing (but not limited to) Microsoft technologies. This year, the event is even bigger as they have merged with the IT Pro event ITPROceed (where I have spoken 3 times in the last years). So I’m […]
Calculate a semi-additive average in DAX
A semi-additive average? What exactly are you trying to calculate? Let me explain first. A semi-additive measure is a measure that can be summed across some dimensions, but not all. Typically it’s the time dimension that isn’t additive. For example, the stock level at various warehouses. You can add all the stock levels of your […]
Book Review – Power Pivot and Power BI
Since Power BI is all the rage right now, I was in need of some material to spice up my knowledge of DAX (read: finally understand how CALCULATE works). I’ve been following the website powerpivotpro.com for quite some time now and they always have very insightful articles about DAX and real world scenarios. Anyway, Rob Collie […]
First thoughts on Power BI on premises
The wait is over, the Reporting Services team finally released a preview for Power BI Desktop reports hosted on premises using Reporting Services! The preview itself is a VM hosted in Azure. You can read all about setting it up in the SSRS team blog post. I toyed around with the VM for a few […]
Power BI Desktop hosted on premises with SSRS 2016
UPDATE 2016-10-27: the preview is available as a VM in the Azure Marketplace. More information can be found on the SSRS Team blog. You can also find my first impressions of the preview in the blog post First thoughts on Power BI on premises. UPDATE 2017-05-08: you can find more information about the Power BI on […]
Slidedeck ITPROceed – Power BI Status Update
I uploaded my slidedeck from the ITPROceed event to Onedrive. For the abstract, see the blog post Speaking about Power BI @ ITPROceed 2016.
My first SQL Server 2016 POC
Very, very recently I did my first Proof Of Concept (POC) with SQL Server 2016. At an actual client of course 🙂 One of the first things I noticed, is that installing SQL Server 2016 is quite fast. Installing the database engine, SSIS, SSAS and SSRS is just a matter of minutes. In contrast with […]