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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ymobbs
Helper I
Helper I

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
v-alq-msft
Community Support
Community Support

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.

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

 

 

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

 

 

 

 

Anonymous
Not applicable

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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