Forum Discussion
stacked line chart - not column
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
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.
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-line-chart-just-bar-char
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-excel/ .Thanks,
Lydia Zhang
6 Replies
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.
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-line-chart-just-bar-char
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-excel/ .Thanks,
Lydia ZhangHi,
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
