stacked line chart - not column

[evalromf]

Hi,

I'm looking for a graph that corresponds to Excel's stacked line chart, where I have one data line from one table, and one from another (with different scales).

What I'd like to achive is something like this:

(The SPD values are found in one table, and POLQA in another. The tables are structured in the same way.)

I can select value fields from the two tables - but I cannot get the two sets of data visible as two separate graphs (as it's only one Y asis formatting that is available in Formatting).

This seems to work when combining a line chart and bar / column chart, but that is not what I want.

This sounds to me as a rather basic feature, and it's available in excel. Is it me that cannot find it?

Thanks in advance for any assistance!

//Eva-Lotta

[Baskar · Accepted solution]

Sorry my dear friend , 

If both are line in same visual we can't  set two Y - Axis.

but if u have one is in Bar and another one line  mean we can do , example go with "Line and Stacked Column" or "LIne and Clustered Column".

if u want two axis u should go with line and column combines visual.

Let me know if any help.

[v-yuezhe-msft · Accepted solution]

Hi @evalromf,

The secondary Y-Axis is not available in Line chart, some ideas about this issue have been submitted in the following links, please vote them up.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12490791-add-secondary-axis
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10454481-multiple-y-axis-on-just-...

Besides other's suggestion, you can consdier to create the Line chart in Excel, then pin the chart to Power BI Service dashboard following the guide in this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-pin-a-tile-to-a-dashboard-from-exc... .

Thanks,
Lydia Zhang

[evalromf]

Hi,

And thanks for the information provided - even though it wasn't what I had hoped for 🙂 I'm amazed that the functionality isn't there already, as it is available in excel. It took me just a minute to created what I wanted in excel:

I'll try the pinning option, even though it's a workaround ...

//Eva-Lotta

[Baskar · Accepted solution]

Sorry my dear friend , 

If both are line in same visual we can't  set two Y - Axis.

but if u have one is in Bar and another one line  mean we can do , example go with "Line and Stacked Column" or "LIne and Clustered Column".

if u want two axis u should go with line and column combines visual.

Let me know if any help.

[Sean]

Wow @Baskar I'm surpised this feature is really missing!

I guess I've been lucky I've only had to use it in Line (Price) and Column (Volume) Charts so I assumed its there for all charts!

But I agree - definitely needed! Hopefully soon!

[Baskar]

My Thinking @Sean
If we think logicaly no need two axis for line chart.

If u create any idea for this let me knoiw i will vote for u my dear friend @Sean

[Sean]

@evalromf

The secondary Y-Axis(Column or Line) is a bit hard to find however it does exist!

You'll have to scroll within the Y-Axis options... Look...

As far as your question you'll have to ideally post some sample data or provide more details