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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors