Power BI

Power BI
12 de agosto de 2021

Data mapping done right

Hi there. In my previous post on how to set up a "data problems" button I did mention that there was a further improvement to the approach, so here I am to explain what is this about. As you may recall, in my previous installment on the topic, the user is warned that there is[...]
Leer post →
Power BI
1 de agosto de 2021

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
10 de julio de 2021

Time Intelligence Dynamic Legend in Line Charts

As I continue my journey with calculation groups I realize that fewer and fewer people may be interested in what I write, but then I think, "so what?" So here I am. My script to create a Time Intelligence Calculation Group based on Daxpatterns.com definitions got a lot of attention (for my standards...
Leer post →
Power BI
9 de junio de 2021

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
4 de junio de 2021

Sorting a Parent-child defined Hierarchy

This is one problem that you don't realize it's a problem until you face it. Happened to me designing a P&L report. For this report, an arbitrary list of items (arbitrary to me of course) has to be displayed in certain order, each with it's own arbitrary calculation, and even with some hierarchy...
Leer post →
Power BI
11 de mayo de 2021

A truly dynamic tooltip

This post is based in a true use case. The customer followed the market share trends, to see how it compared to the rest, as a manufacturer, and at a brand level. So far so good. But coming from excel they were used to build charts any way they saw fit, so they liked to[...]
Leer post →
Power BI
1 de mayo de 2021

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
11 de abril de 2021

Theme-compliant conditional formatting measures

Ok, this is a rather niche use case, but I'll go ahead anyway, basically because I think it's cool. In conditional formatting in Power BI you have three options: By values, by rules and by measure.  In this last case, you have to provide a measure which provides a hexadecimal code, such as #FFFFFF f...
Leer post →
Power BI
24 de marzo de 2021

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 →