Forum Discussion
Microsoft Employeesparkline in matrix
I've a dataset like below
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
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.
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.
(3)Then the result is as follows.
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.
6 Replies
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.
subhendudeThe 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.
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.
(3)Then the result is as follows.
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
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.
