How to replace any value of column in Power BI Paginated report.

[jay_patel]

Hello All,

I am not sure, either i am raising the question into right Service location or not.
I am trying to replace the value into paginated report, into single column like we did using power query editor into power bi desktop, But it doesn't seems easy.

Thanks in advance

[Anonymous · Accepted solution]

Hi @jay_patel ,

In paginated reports, only a non-container item, such as a text box, line, or image, can be replaced by a new report item. For example, you can drag a table into a text box to replace the text box with a table.

If the cell contains a container item such as a rectangle, list, table, or matrix, the new item is added to the containing item instead of replacing it. To replace a container item with a new item, delete the container. Deleting the container item replaces it with a text box, which you can then replace with another item.

For more information，you may refer to ：Change an item within a cell in a paginated report (Report Builder) 

Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.