It’s been a while since I posted anything about my favourite topic calculation groups so I thought I would share this quite simple but useful example that came up in a project I am working on. I had been using a user requested rolling 12 month period in a report…

A really useful application for calculation groups is giving users the ability to control labels and number formats in charts and reports. In a previous post, I showed how you can give users the ability to turn chart labels off and on with calculation groups by using the blank value…

This is a relatively straightforward thing to achieve in a report using calculation groups but nonetheless, very useful and a good introduction to some of the concepts around working with calculation groups. The end result is a column and line combo chart with two slicers allowing users to choose which…

I believe there are many Power BI users who still only only consider the classic example of Time Intelligence in regards to calculation groups but there are so many other types of use cases. The more I explore using calculation groups, the more I am astonished by the things they…

One of my favourite things about calculation groups is the ability to use calculation items as filters. In my last blog post I looked at how to leverage this to pass measures as part of the filter context to a tooltip or drill through page. In this post I want…

I recently posted on Twitter about combining calculation groups to create a tooltip that works for any measure value in a matrix. The idea seemed to get a bit of love from the Power BI community so I decided to write up an explanation of how to achieve it and…