Forum Discussion
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 | 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 !!
3 Replies
- lbendlin
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
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.
- lbendlin
Please use the internet search for the details, for example powerbi - Sparklines in Power BI with SVG - Stack Overflow
