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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Syndicate_Admin
Administrator
Administrator

Chart axis with small multiples

Good morning

I would like to know if there is any way for the Y-axis range to adapt to the data inside.

For example in the case I indicate below, the entire range of Y is based on the data of "Packed table N2", and when you see the data of "Stitching", they come out very small because they are in the same base as the range of the "packed table N2"

What you would need is for the "Stitched" to be the Y-axis range, for example, from 0 to 50 instead of 0 to 2000.

josefmc08_0-1644576817614.png

There is a way that is to put in Scale Type: "Register", but then the secondary Y axis takes its own range and as seen in the graph of "Chain Bucks", the line of 50 of the secondary axis is at the height of 100 of the primary axis.

Let's see if anyone can find a solution.

josefmc08_0-1644577776928.png

Thanks a lot

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Syndicate_Admin , there is an option on-axis in a recent release to start and end as a measure (FX option), see if that can help. 

I doubt that for small multiple to have different axis range. But that option can be explored

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

5 REPLIES 5
amitchandak
Super User
Super User

@Syndicate_Admin , there is an option on-axis in a recent release to start and end as a measure (FX option), see if that can help. 

I doubt that for small multiple to have different axis range. But that option can be explored

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Yes, using the Maximo function, it works perfectly. Thank you

Syndicate_Admin
Administrator
Administrator

Sorry, I already found it. You have to put in Scale type: Registry

Anonymous
Not applicable

@Syndicate_Admin  where is this setting? Scale type registry?

Kudos to you

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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