Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
APPLIES TO:
Power BI Report Builder
Power BI Desktop
In Power BI paginated reports, you can format any part of the text in a text box independently, and mix placeholder text and static text in one text box. This ability to mix formats and add placeholder text enables you to create mail merges or templates for text in your paginated report. Any expression can be defined and formatted separately using a placeholder.
Combine multiple formats in a text box
On the Insert tab, select Text Box. Select the design surface, and then drag to create a box that is the size you want.
Inside the text box, select the text you want to format.
Right-click the selected text, and select Text Properties.
Set formatting options. For example, on the General tab:
Tooltip Type text or an expression that evaluates to a ToolTip. The ToolTip appears when the user pauses the pointer over the item in a report
Markup type Select an option to indicate how the selected text will be rendered:
Plain Text Display the selected text as simple text. HTML will be treated as literal text.
HTML Display the selected text as HTML. If the expression value of the placeholder contains valid HTML tags, these tags will be rendered as HTML. For more information, see Importing HTML into a Report (Report Builder and Service).
Select OK.
Repeat steps 2 through 5 for the remaining text you want to format.
Format text and placeholders differently in the same text box
On the Insert tab, select List. Select the design surface, and then drag to create a box that is the size you want. The Dataset Properties dialog box opens. You can use a dataset embedded in your report. For more information, see Dataset Properties Dialog Box, Query (Report Builder).
On the Insert tab, select Text Box. Select in the list, and then drag to create a box that is the size you want.
Type a label in the text box - for example, "My Field:".
Drag a field from your dataset into the text box. A placeholder is created for your field.
For basic formatting, select the placeholder text and then select one of the formatting options in the Font group on the Home tab. For example, select the Bold button.
For more formatting options, right-click the placeholder text, and then select Placeholder Properties.
Select OK. In report design view, the text box should contain "My Field: [FieldName]", where FieldName is the name of your field.
Select Run.
The list repeats one time for every value in the field, and the FieldName placeholder is replaced each time by the value of that field in the dataset.
Related content
- Text Boxes (Report Builder and Service)
- Formatting Text and Placeholders (Report Builder and Service)
- Expression Uses in Reports (Report Builder and Service)
- Expression Examples (Report Builder and Service)
- Add HTML into a Report (Report Builder and Service)
- Tables, Matrices, and Lists (Report Builder and Service)
- Formatting Numbers and Dates (Report Builder and Service)
- Placeholder Properties Dialog Box, General (Report Builder and Service)