Forum Discussion
Small multiples Line Chart Y-axis interval
Hi Team,
In one of our requirements we have used Small Multiples in Line chart to plot percentages . We personally liked auto adjusting of Y-axis based on filter selections However if we have 3 percentages say 4% , 18% and 39% in Y-axis we are seeing only 0% and 20% as intervals and 39% is being plotted somewhere above 20 with out showing 40% in Y-axis interval . This is confusing our users as they may feel the 3rd percentage is somewhere close to 20% but there is a big difference of 19% . Any solution or workaround to achieve this functionality without limiting the interval wpuld be helpful.
Thank you in advance.
2 Replies
Hi! Unfortunately we do not see an option to limit axes in proportion on Auto mode.
You may try putting in couple of indicator lines(constants) on Y axis to align better.
Hi Anonymous ,
At present, it is impossible to do more settings in the small multiple title. My suggestion is to enable the data label, and then manually set the range of the y-axis. The smaller the spacing, the more obvious the gap between changes.
related document link:
Announcing Small Multiples (preview) | Microsoft Power BI Blog | Microsoft Power BI
Create small multiples in Power BI (preview) - Power BI | Microsoft Docs
Best Regards,
HenryIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
