Blog

Esbrina

11 de octubre de 2025

Industrializing Chart Modifications with Visual Calcs, DAX UDFs and C# Scripts

Ok, this article brings together all the topics that I've had in my mind lately. I have talked in the past about Visual calcs and how they break when you swap a field by another, and also how you can play with them to make the line of a combo-chart fly above the columns. As[...]

Esbrina

4 de octubre de 2025

Industrializing Model-dependent DAX UDFs with Tabular Editor C# Scripting: Time intel reloaded!

DAX UDFs are here and as anticipated they are indeed revolutionizing the way we write DAX. Indeed together with the introduction of DAX UDFs, "the italians" presented "daxlib.org" a common repository for sharing Model-independent DAX UDFs. I'm also contributing there and I've seen how many commits a...

Power BI

16 de septiembre de 2025

Automatically create measures with DAX user-defined functions

YES! Public preview is finally here, and DAX UDFs have the potential to change how we write DAX in a big way. If you don't know what UDFs are, head over to Microsoft (and SQLBI of course) and learn everything they have said about them first, no point in repeating it here. If you want[...]

Power BI

7 de julio de 2025

"Copy visuals between reports" and "prepare a report to make it bilingual"

Hello again. Today I'll introduce two new Tabular Editor C# Scripts that might help you at some point if you are already using the PBIR format (which is in preview, so don't rush it!). The first one is to copy a visual, which at first does not look impressive, but remember that swapping fields in[.....

Power BI

25 de mayo de 2025

Two new C# Scripts for PBIR: Replace Fields & Open Visual Json files

In comparison with my previous post, this one was an absolute breeze to write. Just an idea, some little tweaking with ChatGPT and GitHub CoPilot. Both come from the daily little miseries of daily with Power BI. One is replacing fields in a visual, the other one is finding the visual.json file of ce...

Esbrina, Power BI

16 de mayo de 2025

C# Scripting Nirvana v2.0: Now with Reporting Layer!

learn how to build c# scripts for the reporting layer with an existing report that allows parsing the whole pbir report into an structured c# object

Power BI, Fabric

2 de marzo de 2025

Making a Report Bilingual: The full story (Part 2)

Hello again! Before life gets in the way, let's try to wrap this up. If you have not red the first part, please do so before reading this one as some of the outputs of that part are necessary for the process we'll see here. In this post I want to tackle the actual report.[...]

Fabric

5 de febrero de 2025

Making a Report Bilingual: The full story (Part 1)

Hello hello, It's been quite a few months since I last published. As I was going down the rabbit hole at work I thought it would be a good idea to blog my way through the tunnel. It turns out it was not. The sheer complexity of the task and some big gotchas rendered the[...]

Power BI

1 de agosto de 2024

Transforming a regular report into a bilingual one (Part 2): Extracting Display Names of Measures and Field Prameters

Hello again! This article is part of a series, so if you just discover this, I strongly recommend you start from the beginning. Let's continue digging through the visual.json files. Today we'll extract the fields used in visuals and we'll figure out a way to extract the the first column of field par...

Power BI

29 de julio de 2024

Transforming a regular report into a bilingual one (Part 1): Extracting Titles, Subtitles, and Textboxes

Hello again, after some inactivity the blog is flourishing again. It's not really something I control. When there's something I want to write in the blog, I suddenly imagine all the bloggers out there about to write the exact same blog post elsewhere, so I just need to do it, and do it fast. This[....

Power BI

14 de julio de 2024

Building a Referential Integrity Report Page with a C# Script

Hello again! I'm back with the other use case I have in mind for Report-layer scripts. If you haven't read yet my previous blog post I recommend you do this now as we'll be building on that with a more complex use case. When I first managed to develop C# in visual studio I rushed[...]

Power BI

12 de julio de 2024

C# Scripting the report layer with Tabular Editor

Hello! Today's post is quite special for me as I wished that this day would come. When I wrote the article to generate the measures for a dynamic data problems button there was a section that read "So, let’s build this button then. This part, unfortunately cannot be scripted, so we’ll need to work a...

Power BI

26 de mayo de 2024

Comparing arbitrary date ranges in Power BI

Hello there! Today's post comes from an actual requirement that I had heard before but never handled directly. There is some nifty DAX and modeling so lets get to it! (at the very end you will find a script to achieve the end result with no effort! but don't be greedy and read along to[...]

Power BI

1 de mayo de 2024

Showing the path of the selected point in a scatter chart

UPDATE: I was kindly asked by Kerry Kolosko to make a Work-Out-Wednesday challenge for this chart, and when I did, I realized that it's much more simple than I laid out on this article. I keep as proof that finding the best approach is an iterative process! Building the model from scratch also helps...

Esbrina

2 de abril de 2024

Stickers, so cool

Hello everyone With sqlbits, Easter holidays and a bunch of other stuff i haven't posted in a while, but I'm back! Full disclosure, this is a sponsored post, but for a good cause, you'll see in a minute. If you follow me on Twitter you'll know I like swag almost as much as Johnny Winter,[...]

Power BI

1 de febrero de 2024

Reversing selection on a slicer (sort of)

Hello! The other day on the PUG Barcelona whatsapp group there was a question regarding the possibility of reversing the selection on a slicer, with a single click. Apparently this is something you can do on Qlik and the fellow member was trying to migrate that to Power BI as the users are used to[....

Power BI

21 de enero de 2024

"I want it all in one page"

This is a very recurring topic. You carefully build a dataset semantic model for each business process, and when it all looks good in your Power BI App, some top brass requests a top level summary with key visuals from pretty much all the different models. And they ask for it like for tomorrow. What...

Power BI, PowerShell

9 de diciembre de 2023

Building my first near real time model in Power BI

Hello! Today we leave PowerApps aside, but we head into yet another area way out of my confort zone: Programmatic creation and refresh of custom M Partitions! this is not something I really wanted to do, but I found myself with no other option available. Are you ready? Let's do it. As the title says...

Power BI

28 de noviembre de 2023

Detecting selection on field parameters and calculation groups

Hello, The other day I was watching a video from SQLBI and for the first time I had a surprising thought. I thought "Hey, I would not do it like this". In DAX as in other languages, there are some things that are just a matter of style, sometimes is more. Which case is this,[...]

Fabric, Governance, PowerApps, PowerAutomate

15 de noviembre de 2023

Orchestrating Dataset Refreshes with Power Automate and Power Apps (Part 2)

Hello hello, before the topic cools down, let's complete what we started the other day. As a quick recap we built a Power Automate flow that will launch refreshes of Power BI datasets only when certain ETL jobs of the server have successfully completed. And not only that, those datasets that read fr...

Power BI, Governance

29 de octubre de 2023

Orchestrating Dataset Refreshes with Power Automate and Power Apps (Part 1)

Hello hello, it's been a while since my last post because, well because... stuff, you know. Anyway, today I want to talk about a solution I put together at one of my customers in order to orchestrate refreshes, so that dataset refresh once the precedent ETL jobs have successfully completed (n...

Power BI

29 de julio de 2023

Making single measure stacked column chart keep multi-measure color

I know, it's a terrible title, but it's the best I could come up with. This blog post is to explain a workaround for a behavior I detected while playing with a field parameter (all measures) and a stacked column chart. The problem is as follows: If you have more than one measure in the[...]

Power BI

9 de julio de 2023

Industrializing Calculation Groups

Hello! Today (well yesterday by the time I have finished writing this) saw a great use case of calculation groups and I wished I had come up with the idea myself because it's awesome and something that I've come across sometimes. In a table there's a breakdown by month, and at the total they want[.....

Power BI

6 de julio de 2023

The Calculation Group Paradox

Hello, today I'm not writing any type of tutorial. I just want to share a weird behavior I have found in calculation groups, hoping that those that really know about the inner workings can help us comprehend why they behave like that. Calculation groups can be seen as groups of pairs of DAX expressi...