Power BI Report Server Export to PDF + Visibility Toggle

Thank you Expiscornovus 

Hi, Menawhile 

I found a solution:

Here's a reproduction of the issue:

Your current issue:

Here's the solution:

Start by clearing the expressions in your original matrix:

=IIf(Globals!RenderFormat.Name = "PDF", False, True) 

Then, make a copy of this matrix:

Add the following show hidden expression to the copied matrix as a whole:

After adding this expression, normally when we view the report it is hidden:

Then add an expression to the toggle of this copy matrix:

In this way, this hidden copy matrix will be printed when we export the pdf:

Next, we need to hide the original matrix and then place the copy matrix in the position of the original matrix:

When we print, this original matrix will be hidden:

Overlapping the two matrices together is shown in the following figure:

Whether we expand it or not, we export the PDF with all the data:

In summary, the matrix we exported is a hidden identical matrix, and when the user expands the original matrix, it does not affect the entire hidden matrix. A PDF of the export results showing all the data each time was obtained.

Best Regards

Jianpeng Li

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