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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

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
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors