powerBI Archives - Ben's Blog

Clustering in Power BI using R

2021-04-19 Ben Comments 1 Comment

Since 2016 there’s a built-in feature in Power BI that allows us to automatically find clusters within our data.This is a great feature, however, its main drawback is that whenever we add new data into Power BI the clusters need to be manually recalculated for the new data. In this post, I will show how we can implement clustering in Power BI using R and automatically recalculate the clusters whenever we hit the refresh button. What is Clustering Clustering is the…

Read More Read More

AB Testing with Power BI

2020-09-29 Ben Comments 59 Comments

A/B testing, or split testing, is a digital marketing technique that involves comparing two versions of a web page or application to see which performs better.

In this post, I am going to share a step by step guide to implement AB Testing with Power BI.

SSAS/Power BI – Take Calculation Groups to the next level with Tabular Editor

2020-05-24 Ben Comments 0 Comment

Now it’s been a year since the game-changer new calculation groups feature has been released and I just thought that I still haven’t written a post on it. Goals of this Post Use Calculation Groups Use Tabular Editor Advanced Scripting Speed up SSAS/PowerBI model development Create reusbale script Setting up the Environment Power BI: Download here. Tabular Editor: Download here. SQL Server 2019 and later Analysis Services or Azure Analysis Services. At the time of writing this post, Calculation Group…

Read More Read More

Calculation Group in Power BI – Error: Time Calculation Requires selection of exactly one calculation item.

2020-04-21 Ben Comments 4 Comments

I first thought that the recent calculation group feature wasn’t working in a matrix when selecting more than one calculation item from a slicer, until, I realised that all I had to do to fix it was to simply disable the “column subtotals” option. To be honest I find the error message shown by PBI misleading. So if you encounter the error”Time Calculation Requires selection of exactly one calculation item” here is what you have to do to fix it:…

Read More Read More

Dynamic Currency Conversion with DAX in Power BI

2019-09-08 Ben Comments 12 Comments

A common scenario in multinational companies is having to integrate different currency rates across transactional data.

So here is how we can convert and display data in different currencies in Power BI in a few simple steps.

Create interactive R custom visual in Power BI

2019-06-25 Ben Comments 1 Comment

In this short post we will see how can step by step create an interactive R custom visual in Power BI Prerequisites Install node.js: Download and Install the latest version of node.js from the node.js website Install R : Download and install the latest version of R from here.Once R is installed I also recommend you to install R Studio the integrated development environment for R. Enable R scripting in Power BI: In Power BI desktop, go to File >…

Read More Read More

PowerBI – Dynamic Chart Title

2018-02-02 Ben Comments 1 Comment

Unlike Qlikview, the chart titles in PowerBI can only be static. as you can only pass a static text in the title parameter. However, there’s a way around it! The workaround I found is pretty simple you just need to fake a title by creating a measure that contains your title expression and drop this measure into a Card visual. Then by applying the same transparency and colours of your chart you just need to turn off the chart tile…

Read More Read More