Skip to main content
Microsoft Idea

Power BI

New

Allow zeros on log scales

Vote (3) Share
Zack Warren's profile image

Zack Warren on 19 May 2022 02:37:43

If you have zeros (or negatives) in a field being plotted on the Y axis of a line chart, the Log scale option is disabled. It's certainly possible to clean the data (and ideally should be done, but isn't in the real world). Excel has the ability to click through an error and still get the plot to generate. Power BI should have an option like "Ignore zeros and negatives" that will allow you to still turn on a log axis in that case (and maybe give you a floating warning like the "showing significant data points" floating information icon).