Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi all,
This month marks the release of the public preview version of small multiples! We're excited for you to try it out, and we look forward to hearing your thoughts and opinions on the feature.
If you haven't already, check out the blog post here to learn more about how to use small multiples and what we have planned for the feature. Then let us know here or via this survey what you think of the feature!
- the Power BI small multiples squad
It would be really great to be able to make analytics work with small multiples, such as median or average lines. Even if I calculate a measure in context of the small multiples (with ALLEXCEPT) it uses the overall measure. It would be great to be able to present distribution AND central tendency on one chart, such as bin counts and medians/means.
@msftrien is there any progress on getting concatenate labels to work with small multiples? A lot of my charts use concatenate labels (it was even made a default recently) but this then means small multiples can't be used as they look so bad.
Is there something being worked on?
We gradually stopped recommending this feature in our Organization! Tiles with smaller data is literally impossible to compare and ananlyis.
@msftrien is this feature no longer being developed? Are the gaps still being worked on? Thanks
Since small multiples was made generally available, we've moved the additional features to the broader visuals backlog. The top feature of these is unsynchronized y axes, which we hope to have for you soon, but I don't have any more specific of an ETA than that!
Is there any ETA for when concatenate labels will be supported with small multiples? The issue is described perfectly in this thread: https://community.powerbi.com/t5/Desktop/Small-Multiples-Disable-Concatenate-Label/td-p/1862867
@msftrien I'm still waiting for milestones as listed here https://powerbi.microsoft.com/en-us/blog/announcing-small-multiples-public-preview/
Is there some kind of ETA? Thanks.
It would be nice to be able to make the grid dimension dynamic. Per example, if the small multiples are years, the grid dimension is set to 2x2 and only one specific year is selected, it will show the visual in 2x2 with values only on one of the multiple. I would like to be able to see only the selected years without seeing blank multiple in the visual.
Hi,
Just discovered an issue when copying the visual to put in a word or PowerPoint doc. Any small multiples graph just comes up blank. Normal graphs working fine
We have also noticed this issue.
We have noticed the same.
Hello, I am experiencing the following issue with a bar chart when using small multiples.
The bars showing the values of different amounts are out of proportion, unless the Start of the X-axis is set to 0.
The scale of the bars appears normal once the small multiples field is removed.
View below the first chart (with Currency as the Small multiple) showing disproportionate bar sizes for different fields (all with same format) and the 2nd chart with the removal of the small multiples show the proper scaling for the bars.
Does any one have any idea on how to fix it without setting the X-axis Start to 0 (since negative values are also applicable)?
Thank you very much in advance!
This is another more outstanding example of the disproportion of the bar charts under small multiples
Has anyone else faced something similar?
Do you mind sending me a PBIX w/ repro of this issue? Looks like a bug.
It should not always share the axis. There should be an option. The idea of sharing axis value is good. But sometimes we just want to see trends, some windows look good while others cannot be seen because value difference is large. In that case, we want to turn off shared axis value.
Thank you for the feedback. Yes, unshared/unsynchronized Y axis is high on our backlog of features to add. Although we're stretched thin with commitments to many other high-priority features, do know that this is something we find important for small multiples.
Hi,
I just tried to use small multiple with a calculation group and the result it's not as i expected.
In my calculation group, i have 2 items. 1 item formatted in percent and the other as a whole number.
as you can see in the picture below, The Y axis is formatted in percent for the both items. Ideally it should follow the Format String Expression of the item. Also if the ranges for each multiple can be unsynchronized it will give a better display.
Hope this feedback is clear.
Cedric
I have the exact same requirement. However I have three different formats. $, Count and %
Eg:
1. Total Sales Amount ($)
2. Total Orders (#)
3. Percentage Change over time (%)
All three share same X Axis, tell the same story with different data point. Hence a good candidate to be added in Calculation Group and Small Multiple.
Wish each cell uses Formating String defined in the Calculation Group
I'm using the line & stacked column chart type with no secondary Y-axis, and the Auto Y-axis scaling doesn't behave properly for small multiples. Here's the chart with small multiples disabled:
and here's the same chart with small multiples enabled:
With small multiples, the values for the line don't seem to be considered when generating the Auto Y-axis; the line is cut off at the top and does not cover the entire X-axis.
Sorry for the late reply -- is this still an issue? If so, I'll bring it up with the dev team.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
91 | |
87 | |
84 | |
68 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
70 | |
67 |