Forum Discussion

mollipop's avatar
mollipop
New Member
4 years ago
Solved

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

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 🙂

 

 

Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    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.

2 Replies

  • davehus's avatar
    davehus
    Icon for Memorable Member rankMemorable Member
    4 years ago

    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.

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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.