Hi all,Sam Fischer was nice enough to let me know that using the DAX Function PERCENTILEX.INC is probably a better way to find the top or bottom…Apr 1, 2021Apr 1, 2021
Rolling Date Period Slicers With Calculation GroupsIt’s been a while since I posted anything about my favourite topic calculation groups so I thought I would share this quite simple but…Apr 1, 20211Apr 1, 20211
Dynamic Chart Labels with Calculation GroupsA really useful application for calculation groups is giving users the ability to control labels and number formats in charts and reports…Jan 6, 20218Jan 6, 20218
Allowing users to choose any two different metrics to compare in a single chart with calculation…This is a relatively straightforward thing to achieve in a report using calculation groups but nonetheless, very useful and a good…Dec 28, 2020Dec 28, 2020
Fun with Calculation GroupsI believe there are many Power BI users who still only only consider the classic example of Time Intelligence in regards to calculation…Dec 14, 2020Dec 14, 2020
Dynamic Segmentation with Calculation GroupsOne of my favourite things about calculation groups is the ability to use calculation items as filters. In my last blog post I looked at…Nov 30, 2020Nov 30, 2020
Combining calculation groups in Power BI to create powerful reportsI recently posted on Twitter about combining calculation groups to create a tooltip that works for any measure value in a matrix. The idea…Nov 14, 20202Nov 14, 20202