Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How can I do paging in a table?

Hello everyone, I would like to pagin the table in my report. How can I do it?  
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    Please take following steps:

    1)Create two What If parameter as PageNo and ListNo slicers.

    2)Try this measure:

    Measure = 
VAR a =
    ROUNDUP ( MAX ( 'Table'[Index] ) / SELECTEDVALUE ( ListNo[ListNo] ), 0 )
RETURN
    IF ( a = SELECTEDVALUE ( PageNo[PageNo] ), 1, 0 )

    3)Apply this measure to the original table visual by setting measure=1.

       When select values in two slicers, the visual display the page turning function.

    See my attached pbix file.

     

    Best Regards,

    Giotto

v-gizhi-msft's avatar
v-gizhi-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi,

 

Please take following steps:

1)Create two What If parameter as PageNo and ListNo slicers.

2)Try this measure:

Measure = 
VAR a =
    ROUNDUP ( MAX ( 'Table'[Index] ) / SELECTEDVALUE ( ListNo[ListNo] ), 0 )
RETURN
    IF ( a = SELECTEDVALUE ( PageNo[PageNo] ), 1, 0 )

3)Apply this measure to the original table visual by setting measure=1.

   When select values in two slicers, the visual display the page turning function.

See my attached pbix file.

 

Best Regards,

Giotto