Forum Discussion
Pagination in Table Visual
Is there a way to enable Pagination in Table visual? I have a table that has 60 rows. I could not figure out a way to enable paging so i could show 20 rows per page in Table visual.
6 Replies
RE: Pagination in Table Visual
Hi,
Regarding the pagination in table visual question, I was able to builid one using a copy of the code provided on Github https://github.com/jeroenterheerdt/PaginatedTablePBIVisual
porvided by jeroenterheerdt. [I always give the author the credits ;)... ]
I only had to change a few minor things - as I'm thinking of adding other custom features - .. I can confirm the basic code sample provided works fine. Sample below is pretty basic grid... Default value was set to 20 but I changed it to 5...
Page 1Page 2
Hope this helps...There's also a new Custom Visual called Grid
https://app.powerbi.com/visuals/show/PBI_CV_309E6B47_39A5_4681_808F_132AFB230860
Hope this helps.
Good Luck! :smileyhappy:
Hi Sean,
Indeed... I've seen the new grid visual displayed on Custom Visual Gallery. The fact is
that - as some other pretty good ones I've seen - the visual was built
using the CORE version which is now listed as Deprecated. I'm not saying those
are bad. They're fully functional, though I'm personally aiming towards developing lighter versions using
the Power BI Visuals CLI version from now on. The sample I provided was pretty raw
and I am planning to add more custom features.
Anyway thanks for sharing.
Hi MawashiKid,
Could you please elaborate on how you're able to achieve pagination in the "table" visual in Power Bi from the Github solution you have mentioned in your post.
Thanks.
Hey PowerBIGuy1,
This feature is not available yet for the Table visual, but you can vote for the idea here. You also might want to check out the Visuals Gallery located here: https://app.powerbi.com/visuals/
Hope this helps,
Alan
On approach could be to add a column to your data that includes an incrementing number for each page. eg, your first 40 records all carry the number 1, the next 40 records carry the number 2.
Then you could have a slicer that offers 1 & 2 etc and the user can just cycle through those.
Not perfect but might be ok for some data
