Power BI

Power BI
13 de junio de 2022

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
3 de mayo de 2022

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 →
Power BI
9 de abril de 2022

Completely arbitrary tables in Power BI

Hello there, this is not an entirely new technique, but then again, maybe the use case will be useful to someone, so I'll go ahead and put it here. Indeed the idea came once again from the whatsapp group of Power BI User Group Barcelona, great people all around. Paul shared with the rest of[...]
Leer post →
Power BI
3 de abril de 2022

Another way of overriding calculation items in tooltips

Hello there, quite a while ago I wrote a blog post explaining how to override calculation items in tooltip. Basically, if I'm using calc item A and B in a chart, how can I use A B C and D in the tooltip. My solution was to add 2 extra calculation groups with lower precedence,[...]
Leer post →
Power BI
16 de marzo de 2022

Easy Management of Referential Integrity

Referential what? it sounds weird, but it's a rather basic thing: It's like asking, do you have all the product IDs of the sales table in your product table? If you don't, then is when that infamous "blank" appears in slicers and all kind of bad things start to happen. Unless you load everything fro...
Leer post →
Power BI
13 de marzo de 2022

Showing Measure Descriptions in Tooltips

First of all I have to credit Dan Meissner for bringing up the use case in the SML forum. The idea is to add the measure description in the tooltip, somehow. He thought that calc groups might be part of the solution, as they are "aware" of the measures in the filter context and tagged[...]
Leer post →
Power BI
24 de febrero de 2022

Multiple Measure Selector in a Chart

Hello, hello. After another round of presentations that dried my spare time to blog, just today a new use case came to me through a question in the whatsapp group of the Power BI User Group Barcelona. The goal was to be able to select the measures that should be displayed simultaneously on the same[...
Leer post →
Power BI
12 de febrero de 2022

One-click Calculation Groups for your toolbelt

Hello there, today I don't have any new fancy use case for calculation groups or anything else, but rather a repository of links to the best of the best c# scripts... to create calculation groups. The main use of this post is to point people this way when I do a presentation on calculation groups,[....
Leer post →
Power BI
15 de enero de 2022

Incrementally load from SAP, APIs or almost anything

Ok, so today there are no calculation groups in place, but I want to explain a technique to use incremental refresh even when your source does not support query folding as we normally understand it. Let me explain myself: In general the only use case that is widely documented for incremental refresh...
Leer post →