Home » Power BI Visual » Creating a Small multiples charts in Power BI

Creating a Small multiples charts in Power BI

Small multiples chart

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

Small-Multiples-Preview

Small-Multiples-Preview

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.

Small multiples for clustered column chart

Small multiples for clustered column chart

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.

"<yoastmark

Small multiples with Line chart-

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

"<yoastmark

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.

Small multiples charts with Power BI visuals

Small multiples charts with Power BI visuals

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.

Leave a Reply