Forum Discussion

a4's avatar
a4
Helper 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
v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

According your [New Rank] measure, please try to make a small change to it:

New Rank = ([Parameter Value]-1) * 5 + [rank]

 

Here is my original rank and changed rank:

Please use the [New Rank] to replace the original [rank] to display.

 

If you still have questions about this, please for free to let me know.

 

Best Regards,

Giotto Zhi

a4's avatar
a4
Helper III
6 years ago

Hi Giotto

Thanks for the solution.It's working fine but as soon as I change the page no. to 2... and so on tyhe filters(slicer) are not working.Please find the screenshot for the same.

 

 

Kindly request you to reply as soon as possible

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Community Support
    6 years ago

    Hi,

     

    Please create a new rank measure instead of directly adding ([Parameter Value]-1)*5 to your original rank.

     

    Best Regards,

    Giotto Zhi

  • a4's avatar
    a4
    Helper III
    6 years ago

    Hi Giotto

     

    Please ignore my latest reply, I was able to filter out records based on  the Country when I am on third page, but the problem is I want my page slicer to adjust the page number according to the number of records.

     

    Suppose after filtering on the basis of country or any other filter the total number of records are 100, then only two pages should be displayed in page slicer(50 RECORDS per page). Please find the screenshot for better understanding.

     

     

    In the above screenshot after filtering the above records on the basis of country the page number should be reduced to two because there are only 51 records which are having France as their country and also after applying the filter the page no. should be automatically updated to one follwed two and so on depinding on the number of records(50 records per page).

     

    Please reply as soon as possible.

     

    Kind Regards

    Amit Kumar

     

     
     

     

     

     

     

     

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Community Support
    6 years ago

    Hi,

     

    I add some new data to my original test table:

    Please create a new measure:

    IsVisible = IF([Parameter Value]<COUNTROWS('Table')/5+1,1,-1)

    Then add it to this visual filter:

     

    Then i test it, when i choose one country, it shows:

     

     

    If my reply has answered your question, do not remember to mark my reply as a solution.

     

    Best Regards,

    Giotto Zhi

  • a4's avatar
    a4
    Helper 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.