ZhongTr0n

Add a User-Friendly Disclaimer to Your Power BI Report

February 2023
POWER BI | DATA VISUALIZATION

Combine bookmarks and transparant buttons to add a clutter free disclaimer to your reports.

Create a Stacked Funnel Chart

April 2021
POWER BI | DAX | DATA VISUALIZATION

A junior colleague told me it was not possible to create a stacked funnel chart. Taking this is a challenge I tried to use some DAX creativity to create one anyway. The result came out great, so I decided to share the steps and the code with the community. This article covers the full tutorial on how to build on yourself.

Benchmarking Off-The-Shelf Sentiment Analysis

March 2020
PYTHON | SENTIMENT ANALYSIS | POWER BI

Power BI introduced multiple out of the box AI features to generate more advanced insights. One of these insights is a classic sentiment analysis. Being curious on how well this AI feature worked, I decided to do some benchmarking.

Add Category "Other" to Charts

February 2020
POWER BI | DAX | DATA VISUALIZATION

Categorical charts can often become cluttered with too many small partitions. For this reason, data analysts often resort to an aggregated "other" category, which groups all the small partitions. In Power BI it's not possible to create a dynamic "Other category". So I got my hands dirty on some DAX to provide a solution.

Implement AND/OR Selection<

December 2019
POWER BI | DAX | DATA VISUALIZATION

There are plenty of ways to filter your data in Power BI, using both slicers and filters. The default behaviour of Power BI filtering is "and filtering". Meaning, if you select two categories for example location and time, it will only show results that match both of these criteria at the same time. Sometimes you might prefer "or-filtering". And ideally, you might want to toggle in between both modes. I built a solution to help you provide the functionality to the end user.

What is Dax? And Why you Should (or Should Not) Learn It

October 2019
POWER BI | DAX

When working with Power BI, you might have heard of DAX or Data Analysis Expressions. But what is DAX? What can you do with it and is it worth it to invest time to learn it. In this article I try to answer all of those questions for you.

Power BI: How I Started Using Python To Automate Tasks

July 2019
PYTHON | POWER BI | FLASK | WEBDEV

Less data in your Power BI report means better performance. But after spending days building a report, you might have so many widgets that you lose track on which fields you actually used and which ones you could remove from your report. The only way to evaluate this is by going over each widget and writing down which data is used. As a developer I despise manual monkey work, so I wrote some Python to automate this task for me.

5 quick ways to speed up your Power BI dashboard

May 2019
POWER BI | DAX | POWER QUERY

One of the most frequently asked questions I am asked by Power BI developers is how they can speed up their reports. It doesn't take too many widgets or records to bring your report down to a crippling pace. Fortunately there are numerous ways to bring the speed back up. In this article, I share some quick wins you can implement right away to speed things up.