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
Anonymous
Not applicable

How to add multiple line series on line and clustered column chart

Hi, 

 

I have two value i want to display. 

 

First: Price per quarter

Second: Price change in percentage vs last quarter.

 

Ideally i would like to display for both but it seems power bi only allow one line series. It basically summarizes the price change in percentage for all my products into one line.

 

 

 

Can someone help me?

Data set:

Table 0.ProductProduct Price by QuarterYearQuarterMonthDay% Change in Price vs LQ
Prod11.7852017Qtr 4October1 
Prod11.852018Qtr 1January13.51%
Prod11.882018Qtr 2April11.60%
Prod11.842018Qtr 3July1-2.17%
Prod11.772018Qtr 4October1-3.95%
Prod23.152017Qtr 4October1 
Prod23.12018Qtr 1January1-1.61%
Prod23.12018Qtr 2April10.00%
Prod23.1252018Qtr 3July10.80%
Prod23.12018Qtr 4October1-0.81%
Prod30.73252017Qtr 4October1 
Prod30.6752018Qtr 1January1-8.52%
Prod30.62018Qtr 2April1-12.50%
Prod30.60752018Qtr 3July11.23%
Prod30.5572018Qtr 4October1-9.07%
Prod42.2782017Qtr 4October1 
Prod42.2322018Qtr 1January1-2.06%
Prod42.2482018Qtr 2April10.71%
Prod42.222018Qtr 3July1-1.26%
Prod42.1482018Qtr 4October1-3.35%

There is only one change in price vs LQ line series. This is sum of all the percentages of the products. How do i make it so that each product's %change in price is showing as individual line series?There is only one change in price vs LQ line series. This is sum of all the percentages of the products. How do i make it so that each product's %change in price is showing as individual line series?

1 ACCEPTED SOLUTION

@Anonymous ,

 

There is already an idea, you may leave a comment and vote it up.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

@Anonymous  -

I don't think that's an option in the line and column chart.

One potential solution is to overlay a line chart on top of a column chart. It will be very busy, though

Cheers!

Nathan

Anonymous
Not applicable

Hi Natel,

 

Thanks for your advice!

 

That is unfortunate. I remembered that excel has this functionality on combo charts. 

 

Regards,

Jason

@Anonymous ,

 

There is already an idea, you may leave a comment and vote it up.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.