Power BI

Small Multiples With Calculation Groups In LuckyTemplates

In this tutorial, Im going to show you how small multiples visual interacts with two calculation items (calculation group) in a report.

The small multiples is a new visual feature in LuckyTemplates. It can be used in line charts, bar charts, and column charts. To enable this feature, you need to have the December 2018 version of LuckyTemplates Desktop. You can check out my review on this feature in my recent video tutorial. You can watch the full video of this tutorial at the bottom of this blog.

In this tutorial, I’m going to show you how small multiples visual interacts with two calculation items in a report. In this example, I’m using the data from a recent LuckyTemplates challenge we had in LuckyTemplates; the calculation items are Defects and Downtime.

Table of Contents

Creating Calculation Groups

Calculation groups are a collection of measures. They are created in a Tabular Editor, which you can download for free from the internet. You’ll find the Tabular Editor in your External Tools. If you have the latest version of LuckyTemplates Desktop, it should popup automatically as shown below.

Small Multiples With Calculation Groups In LuckyTemplates

To create calculation groups, we click on the Tabular Editor, and go to Tables, then Create New – Calculation Group.

Small Multiples With Calculation Groups In LuckyTemplates

We’ll call this Measure Selection. Next, we’ll add a calculation item, and we’ll call it Defects. Under this calculation item, we’re going to use the measure Total Defects that I’ve already created for this report.

Small Multiples With Calculation Groups In LuckyTemplates

Then, we create the other calculation item, which is the Downtime, and we also place the measure that I already created for this calculation.

Small Multiples With Calculation Groups In LuckyTemplates

Then, we click save and refresh the report as well.

Small Multiples With Calculation Groups In LuckyTemplates

Interactive Report With Small Multiples Visual

Here, we have created a new slicer and put our Measure Selection into this slicer.

Small Multiples With Calculation Groups In LuckyTemplates

And now we can see that it’s working well and it’s very interactive. We can click through the slicers and the report shows us the data really effective.

Small Multiples With Calculation Groups In LuckyTemplates

We can also choose to have this in a column chart. I’ve added some bookmarks into the report to enable this action.

Small Multiples With Calculation Groups In LuckyTemplates


Introduction To Calculation Groups In LuckyTemplates
Creating Measure Groups – LuckyTemplates Best Practices
Measure Branching: LuckyTemplates Development Strategy

Conclusion

The small multiples visual feature is a new one and so we’re looking forward to seeing more updates on it before its full release. Nonetheless, it’s quite useful now even as its preview version.

I hope you’ve enjoyed this tutorial. Try exploring this feature for yourself a little more and share with us your experience in the comments section below.

Best regards,

Mudassir

More in Power BI