Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Row limlit option for a report

Hi

 

In Power BI, I observe that we don't have an option to limit the number of rows per page i.e. If I have a report with 200 rows, I would like to limit 20 rows per page and hence have 10 pages in total and have an option displayed somewhere on the report, say, below right corner of the report to navigate to and fro from one page to another page (1,2,3, 4 > etc.). It would be very helpful and greatly appreciated if this feature is implemented in Power BI as soon as possible. Thanks!

Need Help

7 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Sonny,

       

      Thank you! It is a very good alternative. However, I am looking for basic page navigation and row-limit option for a simple Power BI grid report. I am pretty sure that Power BI doesn't have this feature yet and I hope they will implement it in the future releases. Thanks again for poiting me to this wonderful alternative!

  • Aron_Moore's avatar
    Aron_Moore
    Icon for Solution Specialist rankSolution Specialist
    8 years ago

    You could add an index column to the dataset and filter each tab of the report to an index range or some label for index groups.

    Then use buttons to implement your navigation requirements.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Aron,

       

       

      I really appreciate the workaround. What if the scenario is not 200 rows but 2000 rows or more? Definitely it wouldn't be advised to have 100 tabs or more as pages and navigate between them. Don't we have an better option in Power BI to achieve this requirement? Please find attcahed for the kind of page navigation I ma looking for. Thanks!

       

       

      • Aron_Moore's avatar
        Aron_Moore
        Icon for Solution Specialist rankSolution Specialist
        8 years ago

        Are the multiple pages required?

        Using the index method you could use a slicer to filter the entirity of a one page report to show only the data from "page 1", "page 2", etc.