Skip to content
Home ยป Small Multiple Line Chart Power BI Custom Visual

Small Multiple Line Chart Power BI Custom Visual

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"
)
Lets drag the these measures in chart’s values fields.
After doing this, you can see now Small Multiple Line chart displays the category wise sales for each Region and Year.
You can also set data color,ย  Line shape and style for each measure under Line styling
Also Read..




SQL Basics TutorialSQL Advance TutorialSSRSInterview Q & A
SQL Create tableSQL Server Stored ProcedureCreate a New SSRS Project List Of SQL Server basics to Advance Level Interview Q & A
SQL ALTER TABLESQL Server MergeCreate a Shared Data Source in SSRSSQL Server Question & Answer Quiz
SQL DropSQL Server PivotCreate a SSRS Tabular Report / Detail Report
..... More.... More....More
Power BI TutorialAzure TutorialPython TutorialSQL Server Tips & Tricks
Download and Install Power BI DesktopCreate an Azure storage accountLearn Python & ML Step by stepEnable Dark theme in SQL Server Management studio
Connect Power BI to SQL ServerUpload files to Azure storage containerSQL Server Template Explorer
Create Report ToolTip Pages in Power BICreate Azure SQL Database ServerDisplaying line numbers in Query Editor Window
....More....More....More




 1,633 total views,  1 views today

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.