creating pagination using play axis

[Anonymous]

Hi all,

I had a requirement, I'm trying to solve but it is not working.

I'm using this columns:  
main goal: I want to show it as a slide show in table visual.

1. I want in a table visual it should show only Action status = 2 and 3, it should sorted descending.

2. I want index column & pagination for that visual, 10 records by using play axis custom visual. in the same visual index should be ascending like 1,2,3,4.

3. the pagination index numbers should be continuous. For example in page1 it should show 1 to 10 records, the nxt page should start from 11

[Anonymous]

Hi @amitchandak , I created a pagination, i want the s.no dynamically, if i sort the other columns in a table visual descending and ascending also it should show ascending serial number ex: 1,2,3,4...etc

[v-xiaotang]

Hi @Anonymous 

Do you mean you want the s.no changes dynamically according to the column you select to sort?

if you sort column1, then s.no shows the order of column1,

if you sort column2, then s.no shows the order of column2?

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , refer to this and play axis visual

https://www.fourmoo.com/2017/10/31/power-bi-how-to-do-pagination-in-power-bi-reports/