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
evalromf
Helper I
Helper I

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:

 

Capture.JPG

 

(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

2 ACCEPTED SOLUTIONS
Baskar
Resident Rockstar
Resident Rockstar

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.

 

 

View solution in original post

v-yuezhe-msft
Employee
Employee

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

Community Support Team _ Lydia Zhang
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

6 REPLIES 6
v-yuezhe-msft
Employee
Employee

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

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

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:

 

Capture.JPG

 

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

 

//Eva-Lotta

Baskar
Resident Rockstar
Resident Rockstar

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
Community Champion
Community Champion

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! Smiley Happy

Baskar
Resident Rockstar
Resident Rockstar

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
Community Champion
Community Champion

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

 

Show Secondary.png

 

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

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.