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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Niharika_C
Employee
Employee

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.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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