Forum Discussion
How can I do paging in a table?
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
Community ChampionDo you think there will be 2 pages or 1000? Let's start there.
Hi Greg_Deckler,
In general, I think 2 or 3 pages will be enough. Let's say there are 30 records in the table. The number of records in the table may increase. I want paging as the number of records increases. For example: Let's say there are 50 records. It should be 5 pages with 10 records.
- Greg_Deckler
See attached PBIX below, I show both methods, bookmarks and buttons and slicers.
Hi Greg_Deckler ,
Thanks for be interested. So can I do it as Datatable or grid? In this way, the visuality will be slightly distorted.
- Greg_Deckler
Maybe. You can check out all of the third party visuals available (hundreds) or write your own.