Forum Discussion

Licantrop0's avatar
Licantrop0
Microsoft Employee
8 years ago
Solved

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.
Reports
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    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 

Breticious's avatar
Breticious
Helper I
8 years ago

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.