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
Fabcon_Europe_Social_Bogo

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.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

Top Solution Authors