Edit

Share via

Add code to a paginated report (Power BI Report Builder)

  • Article

APPLIES TO: Power BI Report Builder Power BI Desktop

In any expression, you can call your own custom code in a paginated report.

Embed code written in Visual Basic directly in your report. For more information about other references you can make from your code, see Custom Code in Expressions (Power BI Report Builder).

Add embedded code to a report

  1. In Design view, right-click the design surface outside the border of the report and select Report Properties.

  2. Select Code.

  3. In Custom code, type the code. Errors in the code produce warnings when the report runs. The following example creates a custom function named ChangeWord that replaces the word "Bike" with "Bicycle".

    Public Function ChangeWord(ByVal s As String) As String
   Dim strBuilder As New System.Text.StringBuilder(s)
   If s.Contains("Bike") Then
      strBuilder.Replace("Bike", "Bicycle")
      Return strBuilder.ToString()
      Else : Return s
   End If
End Function

  4. The following example shows how to pass a dataset field named Category to this function in an expression:

    =Code.ChangeWord(Fields!Category.Value)

    If you add this expression to a table cell that displays category values, whenever the word "Bike" is in the dataset field for that row, the table cell value displays the word "Bicycle" instead.

Next steps