Creating a Small multiples charts in Power BI

In Power BI December 2020 updates, Power BI has released preview version of the small multiples feature!.

Now, you can create a small multiples on your bar, column, line, and area charts.

Prerequisite

Download Power Desktop latest version – https://powerbi.microsoft.com/en-us/downloads/

Let’s get started-

Download Sample dataset- Global_superstore_2016.xls

Follow these steps to create a small multiples:

Step-1: Import Orders dataset from Global superstore file.

Step-2: Enable small multiples preview – click on File tab > Option & settings > Option > Preview feature > Select small multiples

Step-3: These changes required restart, so save the changes and re-open the file.

Small multiples with clustered column chart-

Add one clustered column chart into Power BI report page with some fields as mentioned below-

Axis: Drag year from Order Date

Values: Sales & Profit

Small multiples: Category

It will divide Category into small multiples charts under one visual as you can see in below screen shot.

Formatting Small multiples chart:

You can set the font size, font family & grid layout for small multiples chart. For this select visual & go to format section and follow these two important properties for chart-

Small multiple title – It allows you to change the title font-family, text size, alignment, position & color for small multiples charts.

Grid layout – Set the number of rows & columns for small multiples charts.

You can see in below screen shot, Grid layout for Rows & Columns are 2, so it will divide your chart into a 2×2 grid.

You can change the grid layout rows & columns number as per your need.

Small multiples with Line chart-

Add line chart into Power BI report page and drag some columns as mentioned below.

Small multiples feature with other Power BI native visuals-

You can use small multiples with Line chart, column & bar chart, Area & Area stacked chart, 100% column & bar chart.

Refer more Power BI visuals- Power BI Visuals

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome.