[PowerBI Drops] Advanced Table Customization: Column totalizers

Get full control of operations in tables by customizing column totalizers

PowerBI is the leading visualization, interactive reporting, and dashboard tool used by small, medium, and large organizations. The out-of-the-box features already meet most of the needs for building interactive visualizations.

However, in some cases, the demands are more specific and are not always met by the no-code settings of the tool. This post will demonstrate how we can apply specific transformations to the PowerBI table look.

Imagine the following case: we have the price charged in different years (2021 and 2022), and we need to calculate the inflation between prices, but in the totalizer row, the stakeholders would like to see the inflation between product totals.

We can start by creating a measure to perform the inflation calculation, using the following DAX code:

Doing this, we get the following result using PowerBI’s native column totalizers: