Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
subhendude
Microsoft Employee
Microsoft Employee

sparkline in matrix

I've a dataset like below

subhendude_0-1669195763199.png

I would like to display it in the matrix table in the following format. The issue is with the sparkline. I can't add the sparkline similar to what is shown in the image below

subhendude_1-1669195833550.png

Instead of adding it to the last column, it adds next to each column with a dot(a single datapoint). Any suggestion how can I show the same visual using a matrix table.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @subhendude ,

 

(1)In Power BI Desktop, go to File > Options and settings > Options > Preview features, and select Sparklines.

(2)Select the dropdown arrow next to one of the numeric fields, and select Add a sparkline.

vtangjiemsft_1-1669270824083.png

(3)Then the result is as follows.

vtangjiemsft_2-1669270855041.png

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

View solution in original post

6 REPLIES 6
emily_anderson
Frequent Visitor

I was hoping to find the same solution but what has been provided here is not what was originally asked. The spark line needs to be to the right of the columns not after each column. I have searched all over for a solution to this. One table on the left, a single sparkline on the right for each row. Sigh.

Anonymous
Not applicable

Hi @subhendude ,

 

Please refer to the following document to create sparklines, please note the limitations of sparklines.
Power BI supports up to five sparklines per visual, each showing up to 52 points.
For performance reasons, when the sparkline is turned on, the maximum number of columns in the matrix is also limited to 20.

 

Create sparklines in a table or matrix in a report (preview) - Power BI | Microsoft Learn

How To Create A Sparklines In Power BI Tables And Matrix Visual? (c-sharpcorner.com)

Add Saprkline to matrix in Power BI - SqlSkull

Sparkline in Power BI - RADACAD

 

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

Anonymous
Not applicable

Hi @subhendude ,

 

(1)In Power BI Desktop, go to File > Options and settings > Options > Preview features, and select Sparklines.

(2)Select the dropdown arrow next to one of the numeric fields, and select Add a sparkline.

vtangjiemsft_1-1669270824083.png

(3)Then the result is as follows.

vtangjiemsft_2-1669270855041.png

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

I'm using Power BI Desktop version January 2024, and I can't see Features Preview under File and thus I'm not able to see the option of adding Sparkline in the drop down menu

 

You have to go to File > Options and Settings > Options > Preview Features > Sparklines

 

emily_anderson_0-1724393454155.png

 

The links dont say creating the sparkline with the time series columns and stepped layout on. Appreciate if you can try it out since I've shared the dataset as well.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

Top Solution Authors