Edit

Share via

Specify logarithmic scale in Power BI paginated reports (Power BI Report Builder)

  • Article

APPLIES TO: Power BI Report Builder Power BI Desktop

If you have data that is logarithmically proportional, you may want to consider using a logarithmic scale on a chart in a paginated report. This scale helps improve the appearance of the chart by making your data more manageable. Most logarithmic scales use a base of 10.

This feature is only available on the value axis. The value axis is usually the vertical, or y-axis. On bar charts, however, it is the horizontal, or x-axis.

If your axis is logarithmic, all other properties relating to the axis are scaled logarithmically. For example, if you specify a base-10 logarithmic scale on your axis, setting an axis interval of 2 generates intervals in magnitudes of 10 to the power of 2, or 100. This means your axis values read 1, 100, 10000, instead of the default result of 1, 10, 100, 1000, 10000.

You create and modify Power BI paginated reports in Power BI Report Builder.

Specify a logarithmic scale

  1. Right-click the y-axis of your chart, and click VerticalAxis Properties. The VerticalAxis Properties dialog box appears.

  2. In Axis Options, select Use logarithmic scale.

  3. In the Logbase text box, type a positive value for the logarithmic base. If no value is specified, the logarithmic base defaults to 10.

Related content