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 IV
Super User IV

Re: Is logarithmic scale in power BI possible?

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


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

Microsoft v-huizhn-msft
Microsoft

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
Microsoft Phil_Seamark
Microsoft

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!

Anonymous
Not applicable

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.

Microsoft Phil_Seamark
Microsoft

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?

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors