Forum Discussion

Vaishnavi_M's avatar
Vaishnavi_M
Icon for Helper I rankHelper I
9 years ago

Is logarithmic scale in power BI possible?

HI ,   Is logarithmic scale in power BI possible   Thanks In Advance .
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Vaishnavi_M,

In scatter chart, the "Log" option is available in Scale Type property. You can use whole numbers in the resource data and seeing the option to change the scale from linear to log(please review the highlighted in yellow backgroud).



Log scale type is not available in bar charts and column charts currently based on my research.

The command R statement and create R visualization. The logarithmic scale can be used in R stament. For example, you can use ggplot2 function. 

Thanks,
Angelia

B_Real's avatar
B_Real
Icon for Advocate IV rankAdvocate IV
8 years ago

Log scale is now available on column and bar charts, but I also just hit that wierd little snag where the log option doesn't appear until you set the start value to 1. 

 

Odd behaviour!

  • gerhick's avatar
    gerhick
    Regular Visitor
    8 years ago

    I found this thread by trying to overcome this very problem... For what it's worth, I now realise that it's not just values of 1 that you need to enter... Any non-zero value (other then 'Auto') will work... Just type in any suitable number.

    • Phil_Seamark's avatar
      Phil_Seamark
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi gerhick

       

      They fixed that 'bug' a couple of months ago.

       

       

      • gerhick's avatar
        gerhick
        Regular Visitor
        8 years ago

        Really??? I'm here because I just had the same issue... using Version 2.58.5103.501 (May 2018)... 

        Have I missed something?

  • gerhick's avatar
    gerhick
    Regular Visitor
    8 years ago

    For what it's worth, I found this thread by searching... but it's not just a value of 1 you need to enter... It seems to be any value other then 'Auto'...