Use button to go to next ID

[EricHulshof]

Hi,

I have a data set looking like this:

ID	Text
1	One
2	Two
3	Three
4	Four

Now i want to create a table like this:

1

One

When i click on a + button it should go to 2, then 3 etc. and a - button it should go back.

is it possible to create a measure calculating current selected ID and do +1 and use that ID for the next calculation?

Thankyou.

[Anonymous · Accepted solution]

Hi Eric,

It is not practical to work with this kind of control in Power BI, a great solution you could use is paginated report in a premium capacity or a PowerApp embedded in your Power Bi Report.

But, let's show you something that could help you somehow!

I have created the same structure as mentioned by you, a table with two columns, being ID and Text both of them.

After that I added a slicer in a horizontal orientation. and then I added the ID you mentioned.

By this way, you can filter your table. It's not Button A+ or A-, for that for that I do recomend paginated report or PowerApps embedded as mentioned above.

If you want to make pagination, it will works in a great shape, but maybe we have better ways to work with that!

I hope that I Helped you today!

If you think this helped to reach your goal, mark it as a Solution!

Take Care!

[EricHulshof]

I believe the paginated report is what i needed. A powerapp is also a great idea i'm going to look into. 

Unfortuniatly the solution provided will not work as the ID's will go in the hundreds.

paginated reports are just to pricey for the company and the value it would add. but thanks for the answer anyway.

I'll look into powerapps or else i just have to figure out something else. 

Thankyou!

[Anonymous]

No worries!

Take care!