Calculation Groups

Power BI

The ultimate hack to set column widths in a matrix

Ok, I have maybe gone a bit overboard with the title, but I think it has some advantages over other hacks out there to establish the column widths of matrix, so here I am to explain how I came up with it and how to use it. The first hack I saw was from Ben[...]
Leer post →
Power BI

Changing display units without a suffix

This may seem trivial, but it did not pop up in my head at first, so might be useful to somebody else. In sales reports, there are lots of numbers. And if it's a large company these numbers may be very large. So depending on the visual, the full number may be a bit too[...]
Leer post →
Power BI

Overriding calculation items on the tooltip

In this post I'll explain how to break the tyranny of the "all filters" that are passed to the tooltip in particular the filters set by a calculation group which are even nastier to get rid of than regular filters. It wasn't intended this way, but this post is sort of a sequel (and not[...]
Leer post →
Power BI

Filtering the impossible with calculation groups

Sometimes we face models which can't be built because we fall into the circular relationship (which Power BI protects us against) or ambiguity (which sits there silently making all our results meaningless). I faced one of this situations the other day at work and found a workaround with --you guesse...
Leer post →
Power BI

Time intelligence -- the smart way

Ok, by now you probably know I'm a liiiiitle too much into calculation groups. Once you try calculation groups there's no going back. Particularly if you do time intelligence analysis (that is comparing values with the previous year, but many other things as well). The reason is that normally you wo...
Leer post →
Power BI

Using Calculation Groups in Calculated Tables

Calculated tables are not used often, because after all, it only combines data that you already have, right? Well, I didn't use them often, until recently. I was shown an excel chart displaying market share among top contenders, but including CY vs PY, then CYTD vs PYTD, then MAT vs MAT-1, and then ...
Leer post →