Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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.
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
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
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
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.
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!
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
66 | |
62 | |
62 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |