Blog
Power BI
4 de June 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...
Read post →
Power BI
11 de May 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[...]
Read post →
Power BI
1 de May 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...
Read post →
Power BI
11 de April 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...
Read post →
Power BI
24 de March 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 ...
Read post →