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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
dtran
Helper II
Helper II

secondary axis

Currently using Power BI Desktop (just downloaded last week). I'm trying to create chart with secondary axis (Y-axis). However, in the tool, when I select from Visualization pane, 'Y-Axis' then 'Show secondary', nothing happens. In the video, I see that underneath that option when it is selected, there are other options to select like position it on 'right' side.  

Please advise.

Dennis

1 ACCEPTED SOLUTION

Hi,

 

Can you try adding the metric (which you want to display in secondary axis ) to the line values 

 Capture.PNG

 

View solution in original post

11 REPLIES 11
Anonymous
Not applicable

How do I get the line chart to stop aggregating? Thanks in advance.

Amitchin_0-1645450421125.png

 

vb84
New Member

Hi in my case sometime it shows secondary axis option & sometimes it doesn't.

Dont know the reason. Kindy susggest the solution.

 powerbi1.pngpowerbi2.png

i found the solution but doesnt seems right

When i do Y axis title tab on off or change the display unit to auto, it shows secondary axis.

 

WillowY
New Member

the link to solution doesn't work, could you please resend? thanks,

Anonymous
Not applicable

Hi @dtran,

 

Can you share us some detailed information about your issue? (e.g. screenshots, sample file, chart type, operation steps...)

 

Regards,
Xiaoxin Sheng

Hi Xiaoxin,

 

I have a dummy pbix file with the example but I don't see a way to upload to here. 

How can I upload file or upload screenshot?

 

thanks!

Anonymous
Not applicable

Hi @dtran,

 

You can use photos button to upload the screenshots, sample data your can upload to 1drive and paste the link.

Capture.PNG

 

Regards,

Xiaoxin Sheng

Capture.PNG

See blue arrow

1) The chart isn't showing the secondary axis

2) From videos I've seen that there should be more options below once it is set to 'On'. But there's nothing showing here.

Hi,

 

Can you try adding the metric (which you want to display in secondary axis ) to the line values 

 Capture.PNG

 

Just what I needed, simples.

Thanks Thiyags!

It works now.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

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.

Top Solution Authors