Y Axis and Log Scale

[Licantrop0]

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.

[Breticious]

To 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.

[v-qiuyu-msft · Accepted solution]

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 

[v-qiuyu-msft]

Hi @Licantrop0,

I have reported this issue internally: CRI 49079645. Will update here once get any information. 

Best Regards,
Qiuyun Yu