Calculation Groups

Power BI

A dynamic legend for a dynamic measure + time intel chart

Well it's no secret that I like calc groups. But it's also true that calc groups have an achiles heel. Calc Item names are constant, so for charts, legends stay the same no matter what. Depending on your use case you might get away with it, but sometimes you might get an end user that[...]
Leer post →
Power BI

Activating inactive relationships the smart way

Hi, today I want to talk about inactive relationships. Those relationships with the dashed line that unless you invoque them with USERELATIONSHIP they do nothing. The thing is a common pattern if you read this blog -- let's say you have a retail model, and for some charts you need to use the order d...
Leer post →
Power BI

Defining different formats for values and totals

So today I recevied a question on the SML group which looked like the perfect use case for a calculation group. Somebody was trying to build a matrix and wanted to have the values without decimals but the totals with decimals. In other words the goal was defining different formats for values and tot...
Leer post →
Power BI

Building a fading bar chart

As soon as I learned how to define transparency in HEX encoding for Power BI, I started thinking on how to control it with a calculation group. After all, you can only define transparency through a color measure, so it made sense. If you have seen any of my most recent presentations on Calculation G...
Leer post →
Power BI

Building an arbitrary YOY% growth chart with zoom-out tooltips

I realize that I use the word "arbitrary" a lot on my blog posts, but then I think, "so what?". Anyway, this blog post is mostly a remake on another blog post, the one called "A truly dynamic tooltip". When I wrote that blog post, I had struggled a lot to get the effect I[...]
Leer post →
Power BI

Controlling Calculation Items with RLS

I thought I would let the blog rest for a few days, but I figured out I would write a short one on a topic that Rick brouhgt up on LinkedIn: Controlling Calculation Items with RLS. I lived under the impression that being a table you could just apply RLS like in any other table,[...]
Leer post →
Power BI

Data Validation with Power BI

I know, I'm back again at validations, but this time is a bit different. Recently I've found myselft in a project where the data that was coming in was not fulfilling the sepcified requirements. We tend to thing that data that comes out of a system will always be pristine, but well, at least in[...]
Leer post →
Power BI

Normalizing conditional formatting bars

Ok, this is one of those things that I might not do in production unless I have the CEO shouting on my ear "I want the bars of the matrix to be smaller so I can read the numbers, and no, you may not use a custom visual for that!". I know that might be[...]
Leer post →
Power BI

Creating well-formatted measures based on a calculation group

Calculation Groups biggest contribution is to help us reduce the number of measures that we have to create and manage. However, sometimes, me might want measures again... Of course we can forgo the calc group altogether, but we might want to keep the centralized logic while having actual measures, a...
Leer post →
Power BI

Creating a dynamic KPI card

I'm always keep an eye open for potential new members of the Barcelona Power BI User Group. When I see a potential candidate I try to connect and get to know him/her. Today I was surprised that one of these unsuspected new members told me he was already using my script for Time Intelligence (yay!)[....
Leer post →