Events
31 Mar, 23 - 2 Apr, 23
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
When you want to summarize data in a visual format in a paginated report, use a Chart data region. You should choose an appropriate chart type for the type of data that you're presenting. This choice affects how well the data can be interpreted when put in chart form. For more information, see Charts (Report Builder).
The simplest way to add a Chart data region to your report is to run the New Chart Wizard. The wizard offers column, line, pie, bar, and area charts. For these and other chart types, you can also add a chart manually.
After you add a Chart data region to the design surface, you can drag report dataset fields for numeric and non-numeric data to the Chart Data pane of the chart. Choose the chart to display the Chart Data pane with its three areas: Series Groups, Category Groups, and Values.
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.
Note
The Chart Wizard is only available in Report Builder.
On the Insert tab, select Chart, and then choose Chart Wizard.
Follow the steps in the New Chart wizard.
On the Home tab, select Run to see the rendered report.
On the Run tab, select Design to continue working on the report.
Create a report and define a dataset. For more information, see Report datasets.
On the Insert tab, select Chart, and then select Insert Chart.
Select the design surface where you want the upper-left corner of the chart, and then drag to where you want the lower-right corner of the chart.
The Select Chart Type dialog appears.
Select the type of chart you want to add. Select OK.
Choose the chart to display the Chart Data pane.
Add one or more fields to the Values area. This information is plotted on the value axis.
Add a grouping field to the Category Groups area. When you add this field to the Category Groups area, a grouping field is automatically created for you. Each group represents a data point in your series.
To summarize the data by category, right-click the data field and select Series Properties. In the Category box, select the category field from the list. Select OK.
On the Home tab, select Run to see the rendered report.
On the Run tab, select Design to continue working on the report.
On charts with axes, such as bar and column charts, the category axis might not display all the category labels. For more information about how to change the axis labels, see Specify an axis interval (Report Builder).
Events
31 Mar, 23 - 2 Apr, 23
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
Module
Build reports for finance and operations apps - Training
Organizations have a lot of data. When an organization grows, its ability to provide context for all that data becomes increasingly crucial. Reports can organize data in a meaningful way. Finance and operations apps include reporting tools to help you create reports for your organizations, SQL Server Reporting Services (SSRS), Microsoft Power BI, and Microsoft Excel reports. You can use these reporting tools to visualize a data set in many ways, including as a tabular layout with collapsible tables and by u
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.