Generate the matrix for each value of a filter

[Raph]

Hello,

I have a matrix displaying the sales and the corresponding royalties for an artist which is selected in a filter. I would like to generate automatically the corresponding matrix for every other artists (>400 items) in PDF files. 

Basically I would like to do in Power BI excactly the same thing than this https://www.excelcampus.com/pivot-tables/show-report-filter-pages/#:~:text=Select%20the%20Options%2F...

You may answer that I can use the Analyze in excel feature and do the same thing but this option in excel doesn't work with a Power BI data model.

Thank you for you ideas

Raphaël

[Raph]

Dear @Anonymous 

Thank you for your answer but my request was to find a way to automatically  generate different pages in the report with the same matrix but for each value in the slicer (one page by existing value in the slicer)... like what is showed in Excel in the link mentioned in my previous post. 

Best regards

Raphaël

[Anonymous]

Hi @Raph ,

Please try below steps:

1. below is my test table
Table:

2. add a slicer with "Table[Product]" column, add a matrix with other columns

 

Please refer the attached .pbix file.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Raph · Accepted solution]

Solution is to use the "Row break" option in the Inforiver visual.