cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vaishnavi_M
Helper I
Helper I

Is logarithmic scale in power BI possible?

HI ,

 

Is logarithmic scale in power BI possible

 

Thanks In Advance .

13 REPLIES 13
TickboxPhil
Advocate IV
Advocate IV

Thank you @Phil_Seamark!! My line chart log trajectories of covid-19 deaths on the Data Stories Gallery was fine on log scale, until it later on new data quietly reset itself to linear (like @rstewartusa)! It didn't give me the error when checking in Desktop (just the vague one about being not responsive) but this was the old problem of negatives. I appreciate mathematicians would have a heart attack but as it's only used for scaling, you'd have thought -10,000 could be rescaled in line with the positives (based on the start values!).

 

Anyway, the key is as you say, to set the Start Value - at 1 or 0.1 etc. Then problem solved, even with negatives in the data (but scaled accordingly as thought).

 

It's still a problem in x64 May update 2020, and is not mentioned in the docs! Fair enough to need a start value, but should be clearer or folk will miss out (or worse, it breaks to other users later) on this valuable functionality. Happy logging!

Is it possible to show major and minor lines in a logarithmic scale, similar to that shown on the Excel scatter chart shown below?Excel Logarithmic Scatter Chart with Major and Minor LinesExcel Logarithmic Scatter Chart with Major and Minor Lines

v-huizhn-msft
Microsoft
Microsoft

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

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

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.

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!

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

Have I missed something?

Try using a Start value of 0.1

 

I had struggled with a similar issue - I had set up a combo chart (line + stacked column) with a log scale and it worked fine... but when I made some unrelated changes to some of my measures, the scale changed back to linear!

 

When I checked the Format panel, the Y-axis option for Scale type no longer showed "Log". Instead, it had a yellow triangle, with the tooltip message: "Can't apply log scale - The axis changed to a linear to accommodate both negative and positive values. To use a log scale, remove one set". 

 

NOTE: I am confident my measure values did NOT have any negative values - I used a table visual to manually inspect the data. Then I even wrapped my measure in an IF statement to check if the measure value is < 0 and, if so, set the measure value to 0.  But I still got the same error message.

 

Based on the advice in this forum, I tried entering a non-zero value in the start value, but unfortunately that did not work.

 

However, if I changed the Start field to a value *between* 0 and 1 (I started with 0.1) then it worked! The Log scale was magically back.

 

I then discovered that by changing the Start value (0.01, 0.001, etc.) I could change how "steep" the log axis values changed.

 

I did an extensive web search about this issue, but this forum was the closest I found to a solution.

 

Hopefully this modified workaround works for others.

 

EDITED: to add my current version: 2.59.5135.421 64-bit (June 2018). I don't know if this workaround will work in other versions.

I thought you used to have to enter a 0 for the start value, but I thought they changed it so you could have a value of 1. 

 

Sorry if it doesn't work, I was just working off memory.


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

Proud to be a Datanaut!

gerhick
Regular Visitor

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

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

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

Greg_Deckler
Super User IV
Super User IV

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


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors