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.
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.