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

Stacked Bar and Line Chart- Line Series

Hello,

 

I am trying satcked bar chart with line of all brands. 

But i can only select column series and put my brands in stacked bar for that month. 

But for Line chart I get an average of the all brands for that month. I don't get any indivual line of brands for that month with the stacked bar.

 

Any help would be appreciated.

POwer BI.png

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Stacked Bar and Line Chart- Line Series

Hi @rajatamin18,

 

There is no Line Series property in line and stacked column charts. If we want to plot more than one lines to display value for each column series, we need to create corresponding number of measures to calculate value for each series. And place those measures in Line Values.

 

w1.PNGw2.PNGw3.PNG

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
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

5 REPLIES 5
ankitpatira Community Champion
Community Champion

Re: Stacked Bar and Line Chart- Line Series

@rajatamin18 If I understood you correctly what you need to do is create measure that gives you average of individual brands and then drop those measure fields into Line values section of the visual. That way you will get multiple lines, one for each brand.

rajatamin18
Regular Visitor

Re: Stacked Bar and Line Chart- Line Series

Hi @ankitpatira,

 

As per your solution I can get it in the line chart.

 

But I want all brands trend line as well as all brands stacked in the same charts. 

 

Using the line and stacked chart.

 

Super User I
Super User I

Re: Stacked Bar and Line Chart- Line Series

@rajatamin18 the stacked bar and line chart cannot display multiple lines.


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!
Community Support
Community Support

Re: Stacked Bar and Line Chart- Line Series

Hi @rajatamin18,

 

There is no Line Series property in line and stacked column charts. If we want to plot more than one lines to display value for each column series, we need to create corresponding number of measures to calculate value for each series. And place those measures in Line Values.

 

w1.PNGw2.PNGw3.PNG

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
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

Super User I
Super User I

Re: Stacked Bar and Line Chart- Line Series

Whaaaaat. I could swear I've tried to do that before and it didn't work. Apparently not. Thanks for the correction @v-qiuyu-msft


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors