Stacked Bar and Line Chart- Line Series

[rajatamin18]

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.

[v-qiuyu-msft · Accepted solution]

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.

Best Regards,
Qiuyun Yu

[KHorseman]

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

[ankitpatira]

@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]

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.

[KHorseman]

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