Kane Snyder

I have often been asked for career advice partly due to having been in several leadership roles but also because I achieved quite rapid success in my own career. I moved from zero knowledge to a senior consultant position with a top consultancy in a year and a half. I then made principal consultant 11…

This post addresses common scenarios I have encountered where clients require data to be masked in certain ways in reporting. Most often this is to prevent exposing a competitors’ data when showing reports to clients or customers. MASKING COLUMN VALUES Imagine you are building a report that shows metrics for different clients of a business.…

There’s a lot of confusion around calculation groups and you may have asked yourself questions along the following lines: Are they really necessary? What are they good for? Do you even need to learn to use them well? Why are they difficult or seem unpredictable? I’ve made lots of great stuff in Power BI without…

One of the fundamental things missing from Power Bis visualisation capabilities is the ability to easily control data labels. Having to resort to hacks is not ideal but if good data visualisation is important to you then you have too. Here is my ultimate set of calculation groups for controlling data labels! These let you…

Continuing on my exploration of field parameters, in this post I want to share how you can use field parameters and modelling to dynamically sort columns in a table with a slicer and also switch rows and columns in a table. The technique can also be used to change the sort on a hierarchy but…

Like many, I was very excited to see the new Field Parameters feature that shipped in preview in the latest May 2022 release. It enables you to do some things that used to be complex in a really easy way. I thought I would share some initial things I have discovered while exploring the feature.…

I told myself that I would stop blogging about calculation groups this year and delve into other discoveries I’ve made in my Power BI adventures but its just so damn hard! More and more they keep coming up in solutions to complex requirements and effective report design. In this post I want to look at…

If your like me, you may have gotten a little over enthusiastic about calculation groups and dropped a number of them into a report page only to find that while dense with information, the report page or visual can be a bit sluggish to load. In my first post here, I want to share a…