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 i...
Need Help
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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Aron,

         

        Thank you! It is a very good work-around. 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 doen't have this feature yet and I hope they will implement it in the future  releases. Thanks again for the work-around!