How to display different rows of data using a button or drop down list?

[mollipop]

I need the user to be able to select a button that will display the first 100 rows of a table, and a different button to display the next 100 rows and so on. I'm using a table visual to display the data.  I could use a drop down list instead of buttons if that is easier. 

Does anyone know how to do this? I'd be grateful for any help 🙂

[v-yanjiang-msft · Accepted solution]

Hi @mollipop ,

According to your description, here's my solution.

1. Add an index column in Power Query.

2. Create a calculated column.

Rows =
SWITCH (
    TRUE,
    'Table'[Index] < 100, "Rows 0-99",
    'Table'[Index] >= 100
        && 'Table'[Index] < 200, "Rows 100-199",
    'Table'[Index] >= 200
        && 'Table'[Index] < 300, "Rows 200-299",
    'Table'[Index] >= 300
        && 'Table'[Index] < 400, "Rows 300-399"
)

Put the calculated column in a slicer, get the result.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[davehus]

Hi @mollipop ,

One way would be to create an index in powerquery. Create a seperate table with increments of 100 Merge into the table against the index and fill up. This will group the rows by the 100 as required. so 100 200 300 etc.

Hope this helps.

Did I help you today? Please accept my solution and hit the Kudos button.