Forum Discussion
Y Axis and Log Scale
In a column graph with high variance, log Y axis is beneficial to clearly see differences.
but in Power BI, when you select Log scale type in a column or bar chart, it doesn't sort any effect.
Hi Licantrop0,
Please see below response from PG team:
"This is a known limitation - log scales break when zero is included, and bar/column charts include Zero by default to show relative heights. Ask user to set a min value for their value axis, a power of 10 such as 10 or 0.001.
We have a task planned to address this by setting a smart min value, and add warnings if things don't work for log axis (such as zero included in the range)."Best Regards,
Qiuyun Yu
4 Replies
Hi Licantrop0,
Please see below response from PG team:
"This is a known limitation - log scales break when zero is included, and bar/column charts include Zero by default to show relative heights. Ask user to set a min value for their value axis, a power of 10 such as 10 or 0.001.
We have a task planned to address this by setting a smart min value, and add warnings if things don't work for log axis (such as zero included in the range)."Best Regards,
Qiuyun YuTo clarify this for anyone seeing this, in order to get your Area Chart to allow a "Log" scale type in the Y-Axis, your values must all be greater than zero or the "Log" scale type breaks. I had one day of "zero" data and it broke the view completely.
Set a start value!To fix this issue, you need to manually set a Start value in the Y-Axis.
Hi Licantrop0,
I have reported this issue internally: CRI 49079645. Will update here once get any information.
Best Regards,
Qiuyun Yu
