topic creating pagination using play axis in DAX Commands and Tips

creating pagination using play axis

Anonymous — Tue, 16 Nov 2021 14:40:36 GMT

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

Re: creating pagination using play axis

amitchandak — Wed, 17 Nov 2021 10:02:47 GMT

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/

Re: creating pagination using play axis

Anonymous — Wed, 17 Nov 2021 10:08:27 GMT

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

Re: creating pagination using play axis

v-xiaotang — Fri, 19 Nov 2021 08:53:07 GMT

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.