Forum Discussion
Pagination in table visual
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
My Table structure is different from yours. I have a rank measure and I want to show first 50 ranks on the first page and so on.
Hi,
According to your requirement, I create a rank measure to test:
rank = RANKX(ALL('Table'),CALCULATE(SUM('Table'[sales])),,DESC)
Please change the original measure ‘FilterMeasure’ to this:
FilterMeasue = IF([rank]>=([Parameter Value]-1)*5+1 && [rank]<= [Parameter Value]*5,1,-1)
The following steps is the same with my second reply, 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
I don't have any ID field upon which I can write the parameter logic. Is there any way to write the parameter logic on rank.Kindly request you to reply as soon as possible