Small Multiples: a new smart feature in Power BI


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 5: 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 6: 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!



Database specific security in SQL Server
There are many different ways to secure your database. In this blog post we will give most of them a...
SQL Server security on server level
In this blog, we’re going to look at the options we have for server level security. In SQL Server we...
Microsoft SQL Server history
Since its inception in 1989, Microsoft SQL Server is a critical component of many organizations' data infrastructure. As data has...
Power BI Desktop is een prachtige tool om snel data-analyses te kunnen uitvoeren. Je connecteert op een databron, importeert en...
dba image
DBA is not that scary
Often when talking to people who are looking for a career path in the data world I feel like there...
How do you link an SCD Type 2 table in Power Query?
This article uses a simple example to demonstrate how to link an SCD Type 2 table in Power Query to...