Open in app

Sign In

Write

Sign In

Kane Snyder
Kane Snyder

129 Followers

Home

About

Apr 1, 2021

Dynamic Chart Labels with Calculation Groups
72
5

Kane Snyder

Hi all,

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 third of values than the way I have used in this article ( multiplying the highest value in the chart by 0.33 or 0.66). Once I find the time I will see if I can update the article ✌

1 min read

1 min read


Apr 1, 2021

Rolling Date Period Slicers With Calculation Groups

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…

4 min read

Rolling Date Period Slicers With Calculation Groups
Rolling Date Period Slicers With Calculation Groups

4 min read


Jan 6, 2021

Dynamic Chart Labels with Calculation Groups

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…

4 min read

Dynamic Chart Labels with Calculation Groups
Dynamic Chart Labels with Calculation Groups

4 min read


Dec 28, 2020

Allowing users to choose any two different metrics to compare in a single chart with calculation groups.

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…

Power Bi

7 min read

Allowing users to choose any two different metrics to compare in a single chart with calculation…
Allowing users to choose any two different metrics to compare in a single chart with calculation…
Power Bi

7 min read


Dec 14, 2020

Fun with Calculation Groups

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…

Power Bi

7 min read

Fun with Calculation Groups
Fun with Calculation Groups
Power Bi

7 min read


Nov 30, 2020

Dynamic Segmentation with Calculation Groups

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. …

Power Bi

4 min read

Dynamic Segmentation with Calculation Groups
Dynamic Segmentation with Calculation Groups
Power Bi

4 min read


Nov 14, 2020

Combining calculation groups in Power BI to create powerful reports

I recently posted on Twitter about combining calculation groups to create a tooltip that works for any measure value in a matrix. …

Power Bi

5 min read

Combining calculation groups in Power BI to create powerful reports
Combining calculation groups in Power BI to create powerful reports
Power Bi

5 min read

Kane Snyder

Kane Snyder

129 Followers

Power BI fanatic

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech

Teams