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

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Reply
Anonymous
Not applicable

Creating sparklines (without using a table or matrix)

I tried creating sparklines by just making a small line chart and turning off all the titles and background, but the spacing of the chart is just off. The line is never centered and there is always empty space. 

I can't use the built in sparklines for the matrix and table since I can't make cell background transparent, also the sparklines themselves are just tiny. 

2 REPLIES 2
DallasBaba
Skilled Sharer
Skilled Sharer

@Anonymous You can create a sparkline-like visual using a line chart by following these steps:

  1. Insert a line chart on your report canvas.
  2. Add the necessary fields to the Values and Axis categories. Typically, you'll have a Date/Time field for the X-axis and a numeric field for the Values.
  3. Remove or minimize unnecessary chart elements like titles, axis labels, and gridlines. You can do this by selecting the chart and using the formatting options in the Visualizations pane.
  4. If your line chart has data labels, you should turn them off or format them to be minimalistic.
  5. If there's a legend, you can turn it off if it's not needed for your sparkline.
  6. Adjust the plot area of the chart to minimize any space. You can do this by selecting the plot area and resizing it.
  7. Ensure that the background of the line chart is transparent. You can set the background color to be fully transparent in the formatting options.
  8. Format the line to be visually appealing. You can adjust the line's color, style, and thickness to make it more prominent.
  9. If necessary, adjust the Y-axis range to focus on the relevant data. This can help minimize unnecessary space above and below the line.

You can also watch Fernan's YouTube video. He cover the steps https://www.youtube.com/watch?v=EJB__tBsDNE 

 

Let me know if this works for you. @ me in replies, or I'll lose your thread!!!  
If this post helps, please consider Accepting it as the solution to help the other members find it more quickly.

 
Best Regards,
Dallas.
Thanks
Dallas
zenisekd
Super User
Super User

Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.