Line Chart showing spikes because of decimal values

[Anonymous]

To create this graph, I used a simple division using DAX, just a numerator and denominator and then formatted it to 2 decimal places percentage. The problem is the percentage value is so high (99.99x%) that it's showing up on the graph as a spike. I want it to be a straight line and not consider these spikes because I have set it as 2 decimal places. 

https://community.fabric.microsoft.com/t5/Desktop/Line-Chart-showing-spike-due-to-decimal-values/td-... - This question is very similar to my issue but I can't simply change the minimum and maximum values of the y axis because this graph uses a field parameter to switch between different measures, showing a different line. If I manually set a min and max value, the other graphs won't look as good because the setting seems to affect the graph as a whole, regardless of the current field selection from the field parameter. Is there a way to make the graph a straight line without affecting the other fields?

Thank you; any help is appreciated.

[MFelix]

Hi  , 

Have you tried wrapping you measure in a ROUND syntax something similar to:

= ROUND(Divide(Table[Column], Table[Column]),2) 

[Anonymous]

Thank you for the response. I've tried using ROUND but it makes the graph look strange:

Is there a way to limit the graph to 100% (have the line appear at the top of the graph instead of the middle) without using the max/min setting for the y axis? I can't use those because this graph uses a field parameter, so that setting makes the other fields difficult to read; basically, I want to set the y axis max/min for only 1 field.