Add sparklines and data bars in a paginated report (Report Builder)
Applies to:
Microsoft Report Builder (SSRS)
Power BI Report Builder
Report Designer in SQL Server Data Tools
Sparklines and data bars are small, spare charts that convey information with little extraneous detail in a paginated report. For more information about them, see Sparklines and data bars (Report Builder).
In paginated reports, sparklines and data bars are most commonly placed in cells in a table or matrix. Sparklines usually display only one series each. Data bars can contain one or more data points. Both sparklines and data bars derive their impact from repeating the series information for each row in the table or matrix.
Add a sparkline or data bar to a table or matrix
If you didn't do so already, create a table or matrix with the data you want to display.
Insert a column in your table or matrix. For more information, see Insert or delete a column (Report Builder).
On the Insert tab, select Sparkline or Data Bar, and then choose in a cell in the new column.
Note
You can't place sparklines in a detail group in a table. They must go in a cell associated with a group.
In the Change Sparkline/Data Bar Type dialog, select the kind of sparkline or data bar you want, and then select OK.
Select the sparkline or data bar.
The Chart Data pane opens.
In the Values area, select the Add Fields plus sign (+), and then choose the field whose values you want charted.
In the Category Groups area, select the Add Fields plus sign (+), and then choose the field whose values you want to group by.
Typically for sparklines and data bars, you don't add a field to the Series Group area because you only want one series for each row.
Related content
Charts (Report Builder)
Align the data in a chart in a table or matrix (Report Builder)
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