Calculation Groups

Power BI

Completely arbitrary tables in Power BI

Hello there, this is not an entirely new technique, but then again, maybe the use case will be useful to someone, so I'll go ahead and put it here. Indeed the idea came once again from the whatsapp group of Power BI User Group Barcelona, great people all around. Paul shared with the rest of[...]
Leer post →
Power BI

Another way of overriding calculation items in tooltips

Hello there, quite a while ago I wrote a blog post explaining how to override calculation items in tooltip. Basically, if I'm using calc item A and B in a chart, how can I use A B C and D in the tooltip. My solution was to add 2 extra calculation groups with lower precedence,[...]
Leer post →
Power BI

Multiple Measure Selector in a Chart

Hello, hello. After another round of presentations that dried my spare time to blog, just today a new use case came to me through a question in the whatsapp group of the Power BI User Group Barcelona. The goal was to be able to select the measures that should be displayed simultaneously on the same[...
Leer post →
Power BI

One-click Calculation Groups for your toolbelt

Hello there, today I don't have any new fancy use case for calculation groups or anything else, but rather a repository of links to the best of the best c# scripts... to create calculation groups. The main use of this post is to point people this way when I do a presentation on calculation groups,[....
Leer post →
Power BI

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

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

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

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 →