Hi, I am looking for a table in Power BI which has filtering and pagination functionality?

[kavithakesi]

Dear Team,
I am looking for a table in powerBI which has filtering and pagination functionality?
Any input on the above would be appreciated.

[Anonymous · Accepted solution]

HI @kavithakesi,

AFAIK, current power bi table visual does not support these type of features.

Perhaps you can add an index field to your table records and write a custom measure formula with what if parameter filters(page size, page index) to use on the table visaul to achieve dynamic pagination.

Formula:

Pagination = 
VAR currIndex =
    MAX ( 'Table'[Index] )
VAR PageSize =
    MAX ( Selector[PageSize] )
VAR PageIndex =
    MAX ( Selector2[PageIndex] )
RETURN
    IF (
        currIndex > PageIndex * PageSize
            && currIndex <= ( PageIndex + 1 ) * PageSize,
        "Y",
        "N"
    )

Regards,

Xiaoxin Sheng