One of the clients I work for, got a request which includes geofencing. A geofence is a virtual perimeter for a real-world geographic area. It needs at least three different coordinates to create a shape. …

The problem Sometimes you want to have information from “the previous row” in your table. Problem is, your measures don’t have row context, so it doesn’t know on which row it is. Creating a column will solve this problem easily, but generally, it’s best practice to use measures. …

Power BI has always been about making your data visible. By creating pie charts, line graphs, tables, and all other kinds of visuals, you can show organizations their performance in finance, sales, you name it. With KPI Cards you can show if they’re on track with their target, and with…

When I started as a BI consultant, the only way to create page navigation in Power BI was by using bookmarks and my other main use for bookmarks was creating a “Clear filters” button, to reset all my slicers in a report. …

I once had a customer who had a large collection of data from different subsidiaries. These companies were only allowed to see their own, anonymized data, but the Security Officer of the main company also needed to see the Personal Information (PI) of all employees. Eventually we “solved” this by…

Showing Microsoft Forms results in Power BI A few days ago, someone asked me to think of a solution to show the responses of a Microsoft Form in Power BI. During this project, I used Forms, Power Automate, Excel, OneDrive, and of course Power BI. …

A few weeks ago one of my colleagues showed me a PowerShell script to export all Power BI reports from a Power BI Workspace. This could come in handy for back-up purposes (version control is still hard to accomplish) or if you don’t have access to the PBIX files via…

A question I often get is how companies can share Power BI reports with external users, and how they can participate in a workspace. In this story, I’ll show you! The Problem When I want to add an external user to my workspace, I get the following error: I’m very sure that…

In my previous post, I explained how you could create variable thresholds in Power BI for your alerts. In this post, I will explain how you could notify your whole team that something is wrong. …