Forum Discussion
Is logarithmic scale in power BI possible?
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 Anonymous)! 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!
- jhauff770606 years ago
Advocate II
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 Lines