Small Multiples: a new smart feature in Power BI

Recently, a long-awaited feature was added to Power BI: Small Multiples. If you’re not a reporting specialist, chances are a big question mark popped up above your head when you read that. Small Multiples? Long-awaited feature? What are we talking about?

Presenting data in reporting tools

Reporting tools give you the possibility to present your data in various ways. One of the goals people want to achieve with reports and dashboards is the ability to compare measures across multiple dimensions. There are different ways of doing this, which we can show you with some examples. Imagine we want to see our sales by Year, Month and Country. Let’s check out our options. You can download the Power BI file here.

Option 1: we put everything in one visual using a legend

This can be a good solution, but you are limited in your formatting options. For example, it looks strange when you only have two elements on the X-axis. This type of presentation also makes it difficult to compare numbers.

Option 2: we put everything in one visual using a hierarchy on the X-axis

This can be a good solution, but it can become difficult to understand and compare values when the hierarchy creates too many elements.

Option 3: we move elements from the visual to the slicers

This looks pretty clean and gives a lot of insights, but you have to change the slicer to see results for another country. Values for different countries are never shown on one page, making them difficult to compare.

Option 4: we go for the visual approach with interactive filtering

This is similar to the slicer option, but has the advantage that some comparison is possible because we have the total sales per country. At a more detailed level, comparisons become less clear, but we still have some indication.

Option 4: we create a separate visual per country

Of all the previous attempts, this is the best option so far for comparing countries. Unfortunately, there are also some disadvantages to this approach. You need more reporting space because you have to create a visual per country – my frame from the previous options was not large enough. This means you have a hard limit of six to eight countries when you keep default page sizes in Power BI. Another consequence is that the countries shown are fixed. Sales in a new country will not appear here.

Option 5: Small Multiples

This looks similar to our previous option, which is basically because option 4 is already a small multiples solution, although not a dynamic one. So, what do we gain from using Small Multiples? A new chart for every country that we have in our reporting context. A big advantage is that this is one visual, with multiple charts instead of multiple visuals.

Using Small Multiples

Don’t do what I did when I heard we could use small multiples in Power BI, which was to immediately start looking for a new visual. To my disappointment, I could not find any. Then a little voice in my head said ‘RTFM’. Reading the release blog from Power BI made everything clear: there is no new visual because Small Multiples is integrated in several other visuals such as bar charts, column charts, line charts and area charts.

You just have to drag the desired column into the field under the header ‘Small Multiples’. It’s as simple as that. Pretty smart, I reckon!


Small Multiples is a very recent feature in Power BI. And more nifty tools to help you work better with Power BI have also been released over the past months. In our next webinar – on Friday 22 January at 11:30 – we walk you through the reporting tool’s latest updates. And it’s free, so why not join us? Register now!


Parameter sniffing solved with new Parameter Sensitive Plan Optimization feature
If you’re someone that works a lot with Microsoft SQL Server, there’s no doubt that you’ve had issues with an issue called “Parameter sniffing” before....
Creating maps with R and Power BI
The possibilities are infinite when it comes to creating custom visuals in Power BI. As long as you are creative and have knowledge about the...
Reading notifications
Sending monitoring alerts through Telegram
What if you could get the ease of phone notifications for whatever monitoring alerts you need? Then we have a solution for you with the...
Send mails with Azure Elastic Database Jobs
The DatabaseMail feature in SQL Server and Managed Instance is widely used by many professionals. But what if you want similar functionality in Azure SQL...
Sorting matrices in Power BI
Recently I worked on a Power BI project for a client. They had a SharePoint site where they regularly published articles and wanted to pour...
The world of data is evolving
The data landscape has changed dramatically over recent years, the world of data is evolving. In the past, we mainly heard that we needed to...