How to change scale for X-axis in line chart?

[jaryszek]

Hello,

I have a big gap between lines, can i change a scale on line chart? 
If not, what are the alternatives?

Best,
Jacek

[alish_b · Accepted solution]

Hi @jaryszek ,

I believe the gaps between the lines is due to the high variance of data for that variable assigned to sky blue color. You could try either using the secondary axis in the line visual (put all the smaller value fields/measures in Y-axis and put the large one in secondary Y-axis).

Or, you could put them all in Y-axis and turn on the logarithmic scale in Y-axis properties to leverage log scaling (might need user training as most business users are not accustomed to log scales).

Hope it helps!

[v-menakakota]

Hi @jaryszek ,
Thanks for reaching out to the Microsoft fabric community forum. 

I would also take a moment to thank  @alish_b  for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

Best Regards, 
Community Support Team  

[Ahmed-Elfeel]

Hi @jaryszek,
I hope you are doing well...
I am sorry to say that but you cannot change the X-axis scale (its based on categories or time)
But you can:
1-Aggregate [Month-Quarter-Year]
2-Filtering...you can restrict which values appers on the X-axis (Slicer or using zoom slider).
3-Improving readability.....drag your category into small multiple to split lines into separate charts.

But in short: You cannot change the X-Axis cause it is not numerical just showing categories.