DAX

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 →
Power BI
25 de julio de 2022

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
12 de julio de 2022

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
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
11 de diciembre de 2021

Calculating the percentage of targets reached

After a long break due to a truckload of presentations (for my standards) here I'm back again with the blog. I have a pile of ideas, but always the latest idea takes priority as it is hot, it's burning in my head. A guy from the Barcelona Power BI User Group asked me if calc[...]
Leer post →
Power BI
30 de octubre de 2021

A dynamic color gradient for values and totals

It's a loooong title (well, it was "Conditional Formatting with divergent color gradient for values and totals"), but it's exactly what I wanted to achieve when I discovered the limitations of the conditional formatting options in the GUI of Power BI Desktop. The key words are "dynamic" in one hand ...
Leer post →
Power BI
14 de octubre de 2021

Identifying who exported that leaked CSV

Today's topic is more like an academic exercise than a production use case, but there are a lot of learnings along the way and I think it's worth the effort. The other day I saw a tweet by Igor Cotruta that talked about "text fingerprinting". The idea is embedding the user id in invisible characters...
Leer post →
Power BI
2 de octubre de 2021

The ultimate hack to set column widths in a matrix

Ok, I have maybe gone a bit overboard with the title, but I think it has some advantages over other hacks out there to establish the column widths of matrix, so here I am to explain how I came up with it and how to use it. The first hack I saw was from Ben[...]
Leer post →
Power BI
12 de agosto de 2021

Data mapping done right

Hi there. In my previous post on how to set up a "data problems" button I did mention that there was a further improvement to the approach, so here I am to explain what is this about. As you may recall, in my previous installment on the topic, the user is warned that there is[...]
Leer post →
Power BI
1 de agosto de 2021

Overriding calculation items on the tooltip

In this post I'll explain how to break the tyranny of the "all filters" that are passed to the tooltip in particular the filters set by a calculation group which are even nastier to get rid of than regular filters. It wasn't intended this way, but this post is sort of a sequel (and not[...]
Leer post →