Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: Microsoft Report Builder (SSRS) Power BI Report Builder Report Designer in SQL Server Data Tools
Because each chart type in a paginated report has a different shape, data point labels are placed in an optimal location so as not to interfere on the chart. The default position of the labels varies with the chart type:
On stacked charts, labels can only be positioned inside the series.
On funnel or pyramid charts, labels are placed on the outside in a column.
On pie charts, labels are placed inside the individual slices on a pie chart.
On bar charts, labels are placed outside of the bars that represent data points.
On polar charts, labels are placed outside of the circular area that represents data points.
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.
Create a pie chart.
On the design surface, right-click the chart and select Show Data Labels.
Open the Properties pane. On the View tab, click Properties.
On the design surface, click the chart. The properties for the chart are displayed in the Properties pane.
In the General section, expand the CustomAttributes node. A list of attributes for the pie chart is displayed.
Select a value for the PieLabelStyle property.
Create a funnel or pyramid chart.
On the design surface, right-click the chart and select Show Data Labels.
Open the Properties pane. On the View tab, click Properties
On the design surface, click the chart. The properties for the chart are displayed in the Properties pane.
In the General section, expand the CustomAttributes node. A list of attributes for the funnel chart is displayed.
For a funnel chart, select a value for the FunnelLabelStyle property. For a pyramid chart, select a value for the PyramidLabelStyle property.
Note
When this property is set to a value OutsideInColumn, the labels are drawn in a vertical column. There is no way to change the position of the column.
Create a bar chart.
On the design surface, right-click the chart and select Show Data Labels.
Open the Properties pane. On the View tab, click Properties
On the design surface, click the chart. The properties for the chart are displayed in the Properties pane.
In the General section, expand the CustomAttributes node. A list of attributes for the bar chart is displayed.
Select a value for the BarLabelStyle property.
When the bar label style is set to Outside, the labels will be placed outside of the bar, as long as it fits in the chart area. If the label cannot be placed outside of the bar but inside of the chart area, the label is placed inside the bar at the position closest to the end of the bar.
Create an Area, Column, Line or Scatter chart.
On the design surface, right-click the chart and select Show Data Labels.
Open the Properties pane. On the View tab, click Properties
On the design surface, click the series. The properties for the series are displayed in the Properties pane.
In the Data section, expand the DataPoint node, then expand the Label node.
Select a value for the Position property.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register todayTraining
Learning path
Design effective reports in Power BI - Training
This learning path introduces a design process to design and deliver compelling Power BI reports. It begins by describing a proven design process created by leading report design experts. The process encompasses phases to understand the report users and their requirements, explore pleasing report designs, and develop reports all the way into production.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.