Forum Discussion
Creating a Dynamic y-axis on line chart
I'm having the month-year at x-axis and count of opened risks at y-axis. we built the graph by starting max count at Jan and it will decrease by month on month till Dec-25. In this scenario, the curves are apperaing very far and we need it be appear closer.
Hi VPrasad
It depends on your data structure.
To create small multiples, you need a column (not a measure) that splits the chart into smaller charts.
Meaning, if your chart has a legend that you used for lines, that same column can be used to split the chart into small multiples.
But if you dragged three different measures onto the Y-axis,
then yes—you need to create a table that unifies them.
This can work using a parameter table.If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
6 Replies
Hi VPrasad
From the image you shared, it's clear that the issue is not with the X-axis labels, but with the large gaps between the lines — especially between the bottom and top lines on the chart.
What you're actually asking for is a distortion of the Y-axis proportions to make the curves appear visually closer. But any manual manipulation of the Y-axis scale like that is a distortion of the graph and could lead to a misleading interpretation.
If your goal is to make the lines appear closer without distorting the data, the recommended approach is to use small multiples and disable the shared Y-axis. This way, each line will be displayed in its own chart with its own Y-axis scale, preserving the true proportions, while still allowing you to compare behaviors across time by keeping the charts aligned.
You can see an example of small multiples in the linked post (my solution):
https://community.fabric.microsoft.com/t5/Desktop/How-to-create-a-visualization-based-on-selected-measures-in/m-p/4387188#M1367894If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi VPrasad
It depends on your data structure.
To create small multiples, you need a column (not a measure) that splits the chart into smaller charts.
Meaning, if your chart has a legend that you used for lines, that same column can be used to split the chart into small multiples.
But if you dragged three different measures onto the Y-axis,
then yes—you need to create a table that unifies them.
This can work using a parameter table.If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi VPrasad,
Thank you for reaching out to Microsoft Fabric Community.
Thank you Ritaf1983 for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue?
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Thanks and regards,
Anjan Kumar Chippa
