The Small Multiple Line Chart also known as Trellis bar chart is custom visual that is available in Power BI, it allows you to display a series of mini line charts that share the same axes and scale.
As this chart is a custom visual so you need to import this first in Power Bi Desktop then only you can use it.
To implementing the Small Multiple Line chart you must apply the following steps:
Import Small Multiple Line Chart in Power BI
Go to Visualization Pane, click on Triple dots…, then click on Get more visuals.
Once you click on Get more visuals, a Power Bi Visuals Dialog box opens.
Select category ALL then search for Small Multiple Line Chart in search box and click on Add button to import the Visual in Power BI Desktop.
You will also notice that blue tick in Chart’s name that indicate this chart is a Microsoft verified chart.
Once you click on Add button, you will get a notification dialog box, and visual is imported in Power BI desktop under visualization pane.
Implementing the Small Multiple Line Chart
To demonstrate the feature of small multiline chart, here we have taken a Global Super Store Dataset as shown below.
Suppose you want to display the Sales by Region and Year,ย Lets drag the small multiple line chart in report page.
You can see, a Small Multiline Chart generates the series of small multiple lines charts for all the region values which display the total sales for each region in a year.
Formatting the Small Multiple Line Chart
To make it more interactive you can make the changes in chart default formatting.
If you to display specific number of charts per row then you can set the fixed column for chart under SM layout.
Go to format pane, then under SM layout, select Fixed #column in Column Sizing dropdown and specify 3 in # of column text box as shown below.
To adding the labels on the X-Axis of each column of charts, you can turned on the X-Axis by default it is turned off.
To change the Chart background, set SM Styling property.
f you wish to change the line styling, then you can the line Shap and Style as shown below.
Once you finish all the formatting you chart will look like as shown below.
Using a Measures in Small Multiple Line Chart
Lets display the Sales by categories in each region by year.
Here we have separate measure to calculate the total sales for category Office Supplies, Furniture, and Technology.
Furniture = CALCULATE ( SUM ( 'Global-Superstore'[Sales] ), 'Global-Superstore'[Category] = "Furniture" )
Office Supplies = CALCULATE ( SUM ( 'Global-Superstore'[Sales] ), 'Global-Superstore'[Category] = "Office Supplies" )
Technology = CALCULATE ( SUM ( 'Global-Superstore'[Sales] ), 'Global-Superstore'[Category] = "Technology" )
1,633 total views, 1 views today