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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.