Forum Discussion

a4's avatar
a4
Icon for Helper III rankHelper III
6 years ago

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.
Need Help
a4's avatar
a4
Icon for Helper III rankHelper III
6 years ago

Hi Giotto 

 

IsVisible = IF([Parameter Value]<COUNTROWS('Table')/50+1,1,-1) doesn't work for me.Please find below the series of dax which I have used untill now:

 

1.Parameter = GENERATESERIES(1, INT(760/50)+1, 1)(for generating the series,I have used a constant number 760)
2.Parameter Value = SELECTEDVALUE('Parameter'[Page no.])
3.FilterMeasue = IF([New Rank]>=([Parameter Value]-1)*50+1 && [New Rank]<= [Parameter Value]*50,1,-1) (this is applied on visual level filter)
New Rank(Latest) = ([Parameter Value]-1) * 50 + [New Rank] (New rank measure)
 
Please go through my previous reply for problem scenario.Kindly reply as soon as possible.
 
Kind Regards 
Amit Kumar
 
clinton2528's avatar
clinton2528
New Member
4 years ago

How did you handle a web data source with a API that Paginates. It only brings back a limit of about 200 records. I have more records that needs to be retrieved from the API.