cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vaishnavi_M Regular Visitor
Regular Visitor

Is logarithmic scale in power BI possible?

HI ,

 

Is logarithmic scale in power BI possible

 

Thanks In Advance .

11 REPLIES 11
Super User
Super User

Re: Is logarithmic scale in power BI possible?

In what context? A visual? DAX? Query Editor?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


v-huizhn-msft Super Contributor
Super Contributor

Re: Is logarithmic scale in power BI possible?

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

1.PNG

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

Highlighted
Phil_Seamark Super Contributor
Super Contributor

Re: Is logarithmic scale in power BI possible?

For some visuals, the Log option will not appear in the Scale Type drop down until after you override the Start value to be 1 instead of Auto

 

 

log scale.png


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

JmvSteenbergen Frequent Visitor
Frequent Visitor

Re: Is logarithmic scale in power BI possible?

Thanks! Log didn't show up for me until I added a start value of 1. Weird 'bug'..

B_Real Regular Visitor
Regular Visitor

Re: Is logarithmic scale in power BI possible?

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 Frequent Visitor
Frequent Visitor

Re: Is logarithmic scale in power BI possible?

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

gerhick Frequent Visitor
Frequent Visitor

Re: Is logarithmic scale in power BI possible?

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 Super Contributor
Super Contributor

Re: Is logarithmic scale in power BI possible?

Hi @gerhick

 

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

 

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

gerhick Frequent Visitor
Frequent Visitor

Re: Is logarithmic scale in power BI possible?

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

Have I missed something?