Calculation Groups

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[...]
Leer post →
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
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
24 de junio de 2023

Sorting a matrix by a calculation item column

Hi! actually I was writing another blog post, but today I was shown something that can be done with calc groups that I wasn't aware of. And not only that, even though the blog post I was shown had some very clever thinking behind, I found there's still some room for improvement to bring the[...]
Leer post →
Power BI
11 de febrero de 2023

The Ultimate Snapshot Report (part 3)

Hello there,  yes, a third part of the snapshot report and I'm not even sure it's the last one. The thing is that since the last post there has been some major improvements on the set up that I thought are worth sharing. In my previous post I ended up with a small defeat. There[...]
Leer post →
Power BI
26 de enero de 2023

Dynamic headers in Power BI, sort of.

Well, I was happy with the result, but I was even more happy with the reaction on twitter. The dynamic header effect felt like magical to many people, and well, I have many more followers now, thank you all. In case you haven't seen it, here's the video So how did I do it? Short[...]
Leer post →
Power BI
10 de diciembre de 2022

The ultimate snapshot report (part 2)

Hello again. You didn't think there would be a second part, right? well, me neither. But as things turn out, I had to work on another report dealing with snapshots, and this time they wanted something fancier. It took me a while to figure it out, but I like the result so I thought it[...]
Leer post →
Power BI
18 de noviembre de 2022

The ultimate snapshot report

Lately I've been building a report, which had not happened for a while, and I enjoyed the process. The final result too is simple yet effective, so I thought I would share the approach here because, yes, there is a calc group in place that does some of the magic. This approach is valid when[...]
Leer post →