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

[Niharika_C]

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	November	December
10	25	30
40	40	20
70	10	80

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 :

October	SparkLine	November	SparkLine	December	SparkLine
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.

October	November	December	SparkLines
10	25	30
40	40	20
70	10	80

Awaiting responses Soon !!!

Thankyou !!

[lbendlin]

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

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

[Niharika_C]

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.

[lbendlin]

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