Hello,
I have a query I wrote which is currently returning 150 rows and I want to create table type reports to rotate and display on a TV. Because they will be displayed on a TV, simply scrolling the table will not be an option. Using a single dataset I'd like to create 6 reports to show 30 different rows from my list.
In Visual Basic or C# I could write a code to count the number of rows and determine how many times that number is divisible by 30 and then choose which 30 rows to display on each report. If there were 60 rows, it would show the first 30 rows, then the second 30 rows on reports 1 and 2, 3 and 4, and 5 and 6. Or, if there were 180 rows it would show 30 different rows on each report.
I'm using 6 as my lucky number of reports because I can fit 30 rows on each report table and don't anticipate ever needing to display more than 180 rows.
Is there any way I can make a power BI report count the number of rows returned from a dataset and display certain rows based on a calculation? Or is there any other solution for me to break up my data into multiple tables showing different rows on each report from a single dataset?
Otherwise, I can write what I need into the SQL code and utilize 6 different datasets. It just seems wasteful and inneficient to use that many datasets in this case.
Thank you,
