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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
User57639205
Frequent Visitor

Adding Scale to Y Axis Column Chart

Hello

I am currently using a stacked column chart which shows total days on y axis.

Is it possible to add scale/secondary line to convert this into years, so the same y axis as both values, together on the left hand side.

 

User57639205_1-1714745252525.png 

User57639205_2-1714745299225.png



I know i can get two different y axis, one on left, one on right but am curious if there is an option to have both next to each other on

Thank you

 

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @User57639205 
If you want to change the y-axis based on the selection between years/days you can use a field parameters, please refer to the linked guide :

https://www.youtube.com/watch?v=1eurc0EY2Xg

If you want 2 graphs as in the picture that you attached then just create 2 graphs.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

1 REPLY 1
Ritaf1983
Super User
Super User

Hi @User57639205 
If you want to change the y-axis based on the selection between years/days you can use a field parameters, please refer to the linked guide :

https://www.youtube.com/watch?v=1eurc0EY2Xg

If you want 2 graphs as in the picture that you attached then just create 2 graphs.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors