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

Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.

Reply
Anonymous
Not applicable

NEED HELP : I need help in Adding a New TrendLine/ SparkLine Column in a Matrix Visual

Hi ,

 

NEED HELP : I need help in Adding a New TrendLine/ SparkLine in a Seperate Column in a Matrix Visual 

 

We have Data in the below format in a matrix visual 

 

October NovemberDecember
102530
404020
701080

 

 

when add a spark line to the visual, im not getting the spark line in a new column,

rather im getting spark lined for every invidual month data like below :

 

OctoberSparkLineNovemberSparkLineDecemberSparkLine
10 25 30 
40 40 20 
70 10 80 

 

 

 

Please help me -- how to use "all months data" and reperesent them in a SparkLine Trend in a seperate new column like below  using a Matrix visual.

 

OctoberNovemberDecemberSparkLines
102530 
404020 
701080 

 

 

Awaiting responses Soon !!!

 

 

Thankyou !!

 

3 REPLIES 3
lbendlin
Super User
Super User

you have two options 

1. use the built in sparklines.  Set the column header word wrap off and make the individual sparkline columns really small

lbendlin_0-1671311267988.png

2. Create a measure that produces SVG code and only draws the sparklines for the total, not for the individual columns.

Anonymous
Not applicable

Thankyou for your Quick Revert. 

 

We Tried using the Above Suggested option by you, but this point 

 

""1.use the built in sparklines.  Set the column header word wrap off and make the individual sparkline columns really small ""  , this can only be used for a time being purpose not as a full fleged, Clientt-customer report in a long runn.  Formatting the report and matrix visual is also being bit difficult.

 

2. Can You please help us Elaborate , what is the use of SVG Code and How do we use them in representing SparkLines for Months Data .

 

Please help us suggest with any other alternative options if possible.

 

Awaiting your response !!

Thanks in Advance.

Please use the internet search for the details, for example powerbi - Sparklines in Power BI with SVG - Stack Overflow

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.