cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

How to add a trendline/sparkline in a table/matrix in power bi?

Hi,

 

I have this excel table with a column of trendline:

 
Customer NameJan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Sep-19Oct-19Nov-1912 Month Trend
AAA6195174,9601,170102361751600260 
BBB000761,5571,08031188571311,827 

 

Somehow, the trendline doesn't show up in the post... But it's a line that represents the trend of the monthly numbers. 

 
 

Can I recreate a table like this that has a column with a trendline to show the trend of the monthly numbers? 

 

Thank you in advance!

 

Regards, 

Emma 

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: How to add a trendline/sparkline in a table/matrix in power bi?

Hi, @ymobbs 

Based on your description, I have tried to use many visuals to achieve it. You may try to use ‘Power KPI Matrix 3.1.1’ visual from marketplace.

 

I created the sample as follows:

x1.png

Then you may put the columns into the corresponding pane as below.

x2.png

Finally, the result may achieve your requirement.

x3.png

If I misunderstand your thought, please show me your sample data. I am glad to solve the problem for you. Here is my pbix .

 

Best Regards,

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
Frequent Visitor

Re: How to add a trendline/sparkline in a table/matrix in power bi?

Hi @v-alq-msft ,

 

Thank you very much! I tried Power KPI Matrix as well but it is not exactly what I wanted. I'd like to have the exactly same layout as the excel table I pasted in my orignal post: volume by month and by customer with a column showing the trendline/sparkling. 

 

Here's my sample data. Would you take a look and see if you can help me find another solution? Thank you so much!

 

Plant AreaCalendar monthCalendar YearSold-to party Volume 
Area 1JAN20193000323Company 142
Area 1FEB20193000445Company 242
Area 1MAR20193001626Company 3191
Area 2JAN20193006888Company 118
Area 2MAR20193022805Company 20
Area 2FEB20193053753Company 3113.5
Area 3FEB20193121913Company 1156
Area 3JAN20193122053Company 243.5
Area 3MAR20193122053Company 3100

 

 

Highlighted
Community Support
Community Support

Re: How to add a trendline/sparkline in a table/matrix in power bi?

Hi, @ymobbs 

Thanks for providing your smaple data. I have tried with Power KPI Matrix on your smaple data several times and it really can not achieve your requirement. You may post a new idea in Idea Forum, and add your comments there to improve Power BI for making this feature coming sooner. Here is the link. Thanks.

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Best Regards

Allan

 

 

 

 

Highlighted
Frequent Visitor

Re: How to add a trendline/sparkline in a table/matrix in power bi?

Dear @v-alq-msft ,

I think you showcase on your "why Power BI" web page what the user is looking for (his pictures from December are not visible anymore in the forum) to demonstrate self-service capabilities. So I think there must be an easy way to do this.

SparklinesSparklines

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors