Power BI

Power BI
12 de enero de 2022

Charting time as Hours and Minutes

Once again I'll recreate here a use case I found at work because I think it's cool and with some gotcha's that can be fixed. The use case itself is broad enough. We are measuring the duration of an event (working hours, machine runs, etc) and we want to visualize it. Since we want to[...]
Leer post →
Power BI
6 de enero de 2022

Bringing Tabular Editor c# scripts to the next level

Is no secret that if you work daily with Power BI, you should be using Tabular Editor,  but if you are working with lots of different datasets you probably feel like you are doing the same thing over and over again. Then it's time to bit the bullet and get your hands dirty with Tabular[...]
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
24 de octubre de 2021

Building arbitrary tables with 2-level column headers

If you have worked with Matrix visual you probably have faced the problem: Your end user would like to group all the measures that are thrown in into neat little groups, putting all de Quantity- related measures in one group, all the value measures in another, for example. What I've seen so far is t...
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
3 de septiembre de 2021

Changing display units without a suffix

This may seem trivial, but it did not pop up in my head at first, so might be useful to somebody else. In sales reports, there are lots of numbers. And if it's a large company these numbers may be very large. So depending on the visual, the full number may be a bit too[...]
Leer post →