Small multiples Line Chart Y-axis interval

[Anonymous]

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.

[v-henryk-mstf]

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,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AbhiSSRS]

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.