Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Power66
Regular Visitor

Need help with Line and Stacked Column chart

I am building a line and stached column chart, where:

The stacked columns are actaul revenue by business groups, in 

One line graph is the budgeted revenue (no need to seperate by business groups)

One line graph is a ratio in % 

Is there anyway to have the stacked columns and budget line graph use the y-axis on the left, and ratio line use the y-axis on the right side?  It seems to me the visiual is designed with the two line graphs have to share the y-axis on the right side.  But I am hoping there is some settings to allow me change that. 

I am also open to suggustions if there are other custom visual that can presents all the required data in one visual.  Thanks in advance for everyone's help!Line & Stacked column chart.png

2 REPLIES 2
amitchandak
Super User
Super User

@Power66 , The stacked bar and line, can share Left Y axis if needed (If you switch of Secondary axis). But Stacked will not use a secondary(right) y-axis.

 

You can log an idea- https://ideas.powerbi.com/ideas/

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thanks for your attention. I understand the stacked column can only use the left y-axis. And the line graph can share the left y-axis with the stacked column.  What I need is to split the two line graphs: with one line graph shares left y-axis with the stacked column, and the other line graph uses the right y-axis.  Is that possible? If yes, how? Thanks again for your help! 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.