Forum Discussion
Pagination in table visual
I have around 700 records in total.I want to achieve pagination in table visual(50 records per page).Is there any workaround for this?Any help is appreciated.
18 Replies
hi,
According to your description, please try this visual: Grid by MAQ Software.
You can import this custom visual to your report follow: https://docs.microsoft.com/en-us/power-bi/developer/power-bi-custom-visuals#import-power-bi-visuals-from-within-power-bi.
And it shows as follows.
You can set the max rows per page you want.
Here is my pbix test file.
If you still have questions about this, please for free to let me know.
Best Regards,
Giotto Zhi
But this visual doesn't support Hyperlink, any other solution....
hi,
According to your description, please continue to use table visual and create a measure to show its pagination effect.
Here is my test table:
I have six rows and it try to show them with five rows per page.
Please follow these steps:
1)Create a new column and a measure:
Parameter = GENERATESERIES(1, INT(MAX('Table'[ID])/5)+1, 1)
Parameter Value = SELECTEDVALUE('Parameter'[Parameter])
2)Create a measure to paginate the table:
FilterMeasue = IF(VALUE(SELECTEDVALUE('Table'[ID]))>=([Parameter Value]-1)*5+1 && VALUE(SELECTEDVALUE('Table'[ID]))<= [Parameter Value]*5,1,-1)
And then add it to filters:
3)Create a slicer by using the column above:
4)And the result shows:
Here is my pbix test file.
If you still have questions about this, please for free to let me know.
Best Regards,
Giotto Zhi
Hello friend, I have followed your instructions and it ran fine, thank you. But I have an idea that is to get the max rows adjusted directly with a selected button. For example, clicking on selected will dropdown a value like 10, 20 and when selected, the max rows will change. Please help me, thank you, sorry for bothering.
Thank pro
