Blog
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 →