Specify a logarithmic scale in a paginated report (Report Builder)
Applies to:
Microsoft Report Builder (SSRS)
Power BI Report Builder
Report Designer in SQL Server Data Tools
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 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 will be scaled logarithmically. For example, if you specify a base-10 logarithmic scale on your axis, setting an axis interval of 2 will generate intervals in magnitudes of 10 to the power of 2, or 100. This means your axis values will read 1, 100, 10000, instead of the default result of 1, 10, 100, 1000, 10000.
Note
You can create and modify paginated report definition (.rdl) files in Microsoft Report Builder, Power BI Report Builder, and in Report Designer in SQL Server Data Tools.
To specify a logarithmic scale
Right-click the y-axis of your chart, and click VerticalAxis Properties. The VerticalAxis Properties dialog box appears.
In Axis Options, select Uselogarithmic scale.
In the Logbase text box, type a positive value for the logarithmic base. If no value is specified, the logarithmic base defaults to 10.
See Also
Formatting Axis Labels on a Chart (Report Builder and SSRS)
Formatting a Chart (Report Builder and SSRS)
Format Axis Labels as Dates or Currencies (Report Builder and SSRS)
Charts (Report Builder and SSRS)
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om