Forum Discussion
Dividing Matrix on Row Count To Avoid Slidebar
For some monthly company reports I need to setup my report pages to be 'print ready' in order to use PowerBI Robots to automatically take snapshots, convert them to PDF files and email them. However, I am having the hardest time to avoid the slidebar from showing up on visuals.
I need to send out different reports to certain Regions which have their own set of Assets for which some KPI's are reported. A matrix visual shows all Regions and their corresponding Assets (one assets per row) and I use a filter to select the Region. Unfortunately some Regions have too many Assets (matrix rows) to be shown on one page, so I need to split the matrix in two. The first matrix shows the first 10 rows (based on alphabetical order of Asset Names) and the second matrix needs to show the rest.
I tried using the TopN filter, and it works to cap the first matrix on 10 rows, but I don't know how to use this for the second matrix to show 'the rest' of the rows.
An Index column on the source table also didn't do the trick, as I only report on assets in a certain category from this table and therefore the row count 'breaks'.
Preferred solution;
A dynamic row number in the Matrix visual and the possibility to filter on RowNumber <= 10 and Rownumber > 10.
Thank you in advance!
- Anonymous6 years ago
HI RensMatthews,
AFAIK, power bi does not support auto pagination visual records.
You can add a calculated column to calculate the page number of each category, then you can apply it on the visual level filter to display specific page records.
Regards,
Xiaoxin Sheng
1 Reply
- AnonymousNot applicable
HI RensMatthews,
AFAIK, power bi does not support auto pagination visual records.
You can add a calculated column to calculate the page number of each category, then you can apply it on the visual level filter to display specific page records.
Regards,
Xiaoxin Sheng