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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Danfountain
Helper I
Helper I

Calculating the Y Axis maximum

Hi all,

 

So I have a line and stacked column chart.  I need the Line, and the stacked column to work on the same axis.  However that doesnt seem to be possible if using the auto range......

 

So my chart has months on the X axis (commonly the last 12).  The main column measure is a simple one of:

 

Measure_Count = COUNT(Facttable[Key])
 
The line on the secondary Y measure is this
 
Measure_Count_LastPeriod = CALCULATE(Facttable[Measure_Count ], SAMEPERIODLASTYEAR('CalendarTable'[Date]))
 
So I now need to find a way to bring back the maximum for any given periods over the chart based on either of these so i can set that as the maximum.
 
Any ideas how i would do that as i am struggling.  Either that or any other way to keep my Y axis and secondary Y axis in sync.
 
Thanks in Advance.
Dan
1 ACCEPTED SOLUTION
Danfountain
Helper I
Helper I

Please ignore this thread.  I think i have gone down an odd rabbit hole.

View solution in original post

2 REPLIES 2
Danfountain
Helper I
Helper I

For anyone interested its because i had the zoom slider turned on.  If you either display the secondary axis or turn on the zoom slider then it doesnt keep them in sync.  If you leave them both off then it stays in sync 🙂

Danfountain
Helper I
Helper I

Please ignore this thread.  I think i have gone down an odd rabbit hole.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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