Visualizing Home Assistant data in Power BI
Ahhh, Power BI and Home Assistant. Two of my favorite tools. So, why not try to bring them together? I like the Home Assistant data visualizations, but they are limited - that's where Power BI can really…
Updated: Annual radio countdown Top 2000 in Power BI
A bit later this year, but even after my move to the US I decided to keep up the tradition of updating my Power BI analysis of the Top 2000 analysis for this year. Read all about…
Updated: Annual radio countdown Top 2000 in Power BI
This is starting to become a tradition, sort of. My Power BI analysis of the Top 2000 has been updated to include 2018’s edition! Read all about it in the original post from 2016. Full screen Enjoy…
Power BI Connector for CBS Open Data / Statline updated
I have updated the instructions and the code for the Custom Connector for CBS Open Data / Statline. Please see the original post: Power BI Connector for CBS Open Data / Statline
Ultimate Time Based Calculations Cheat Sheet for DAX / Power BI (including Week based calculations)
Power BI provides great time intelligence features to calculate Year-to-date (YTD), Month-to-date (MTD) and Quarter-to-date (QTD) totals. There is no such thing as Week-to-date (WTD) or Period-to-date (PTD) where period could be any arbitrary period definition (I…
Mapping Dutch geographical data using Power BI
I have written before on the subject of using Power BIs mapping capabilities (see the post on ArcGIS) and using the maps with Dutch geographical data (see using Dutch postal codes in Power Map). However, I have…
Dutch elections analyzed in Power BI
Just in time for the elections in the Netherlands: I made an analysis using Power BI of the results of the elections since 1918. It is published (in Dutch) on the official Microsoft the Netherlands blog: https://blogs.microsoft.nl/technologieenmaatschappij/tweede-kamerverkiezingen-technologie-brengt-uitslagen-tot-leven/.…
Annual radio countdown Top 2000 in Power BI
Full screen Most of this post will be in Dutch. Every year a list of 2000 songs is voted on by people from the Netherlands. This list is then broadcast by Radio 2 in the last days…
Passing filters to Power BI reports using the URL / query string
It was only recently that I discovered this – you can pass filters to Power BI reports by deep linking to it and adding a filter in the URL (also called query string). I am not even…
Power BI Custom Visual Development Tip: VisualPlugin.ts: Property ‘Visual’ does not exist error
So here you are, creating your very own Power BI custom visual. You have read the documentation and ran the tutorial (https://github.com/Microsoft/PowerBI-visuals/blob/master/Readme.md and https://github.com/Microsoft/PowerBI-visuals-sampleBarChart). You feel proud because you are done creating your awesome looking 3d-piechart-barchart-mashup visual.…