Power BI

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...
Leer post →
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[....
Leer post →
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...
Leer post →
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...
Leer post →
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,[...]
Leer post →
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[...]
Leer post →
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[.....
Leer post →
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...
Leer post →
Power BI, Governance
25 de junio de 2023

Helping users find Power BI Apps

In Power BI there are plenty of features to allow people discover content, but I don't think it's really useful. For once, with the exception of promoted & certified datasets, you only find what you have access to, and in many places access is given on a one-by-one basis. You ask for it, you get...
Leer post →