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
Trcose
Advocate I
Advocate I

Small multiples: any way to format x/y axis scale individually?

Using SWITCH() and a table of measures, I'm able to use the small multiples feature to display multiple measures for long lists of items/customers/categories in a graph that scrolls together. This feature is a big problem solver for some of the reporting I'm typically asked to build. 

 

One limitation I've found is that if I want to display an actual $ measure and a % measure together, the x/y axis will auto format to accomodate the $ figure, typically meaning the percent figure is not visible. I'm not finding an option to change scale by measure/category in the usual places. 

 

I believe the fix may be listed in the Small Multiples Milestone list:

 

Preview Milestone 2

  • ...
  • Formatting: Y axis ranges can be synchronized or unsynchronized (to allow comparison of trends across multiples whose ranges vary wildly)

 

Beyond this eventual fix, has anyone found a workaround that allows us to set the axis scale of the individual "multiples"? Or does anyone have any insight on how far off Milestone 2 might be? I'm a relatively new user and not sure how long features like this stay in preview. 

11 REPLIES 11
Pedro503
Resolver I
Resolver I

Hey guys, you could refer to this page. It has worked for me.

https://powerbidocs.com/2022/12/03/unshared-y-axis-for-small-multiple-charts/

Very helpful!!! Thanks!

Thanks a lot. This feature is exactly what I needed. I was worried for a minute when I could not find this feature. Without your comment, I may have given up.

Glad it helped 🤙

lavynabcde
Regular Visitor

As far as I know, this feature still isn't available, although it would be very helpful. I voted for this idea: Small Multiple Line Chart with Auto-Adjusting Y-Axis

Anonymous
Not applicable

Has there been any workaround for this feature?

  • Formatting: Y axis ranges can be synchronized or unsynchronized (to allow comparison of trends across multiples whose ranges vary wildly)

I am still unable to synchronize the Y axis in small multiples, I would like to have for each small multiple a Y-axis range that matches the range of data provided.

In the below example: Quality score example, scores can be 0-5 scale or a percentage score 0-100%, depending on the question asked. It is not possible for me to customize each Y-axis of the small multiple. I don't want to build a new visual per question.

What is the solution/work around?

Marion_06_0-1664792254958.png

Tableau is able to customize the Y-axis range for each small multiple:

Marion_06_1-1664792555052.png

darrenfishell
Advocate II
Advocate II

Any updates on this? This is a really critical option to make small multiples useful in many more situations. 

SteveCnz
Advocate I
Advocate I

I am also following up on progress/due date with the preview milestone 2 on option for a synchronized or unsynchronized Y axis on  small multiples.  Has this been completed yet, if not, does the functionaly have a due date for delivery?    Thanks.

pirdim
Advocate I
Advocate I

Is there any news on that "Milestone 2"? I couldn't find a solution and I'm really surprised this feature wasn't added. To me this is a solid "must have" as almost in every scenario when I "play" with absolute values in small multiples chart I see big variation of data. At this point this tool is useful basically only for some relative KPI's like sales per units, % returns etc. 

Can't agree more with you @pirdim 

Seems we aren't getting a straight answer yet as "WHEN" exactly this would be implemented.

amitchandak
Super User
Super User

@Trcose , for new and planned feature you can also refer this page

https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave2/power-bi/planned-features

 

for any limitations, you can suggest an idea or vote for an existing one - https://ideas.powerbi.com/ideas/

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