Forum Discussion
Problem with Log Scale type in Line chart
Log scales only allow powers of ten for axis ticks, and will round 99 down to 10 since there are values below 100. Power BI team plans to address this next semester, but requires significant axis refactoring to get to the desired behavior.
Please refer to following simple sample, if the lowest value is 9, then the start value will still be 0. If the lowest value is 10, then the start value will be 10.
Best Regards,
Herbert
The issue that Prasanthi is facing is related to the "Auto" start option with line graphs and Log scale type.
For example, when we have data as:
110,000
120,000
130,000
140,000
150,000
To opt for scale type as "log" with line chart, one has to select "1" as start in the Y axis properties. If we want auto as a start option, then only "Linear" appears in the scale type selection.
So, for the above case, with log scale type, the Y axis starts with 1 and shows 10,100...uptil the data requires. This deminishes the focus on data for large data points. Intended behaviour would be Y axis starting from 100,000("Auto" start) since there is no data below that.
How to achieve this?