cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerBIGuy1 Frequent Visitor
Frequent Visitor

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 6
alanhodgson Established Member
Established Member

Re: Pagination in Table Visual

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

Phil_Seamark Super Contributor
Super Contributor

Re: Pagination in Table Visual

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


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

MawashiKid Member
Member

Re: Pagination in Table Visual

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... 

CustomersList1.pngPage 1CustomersList2.pngPage 2
Hope this helps...

 

Sean Super Contributor
Super Contributor

Re: Pagination in Table Visual

@PowerBIGuy1

There's also a new Custom Visual called Grid

https://app.powerbi.com/visuals/show/PBI_CV_309E6B47_39A5_4681_808F_132AFB230860

 

Grid Custom Visual.png

 

Hope this helps.

Good Luck! Smiley Happy

MawashiKid Member
Member

Re: Pagination in Table Visual

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.

vinayakk Frequent Visitor
Frequent Visitor

Re: Pagination in Table Visual

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.

@MawashiKid 

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 88 members 1,288 guests
Please welcome our newest community members: