Get report page number as value/measure

[timtack]

Hello Community,

i am working for a use case for write back comments via PowerApps. It works so far for my first report page. My goal is to show/edit page related comments via PowerApps. Every page in PowerBI should have a related comments field through PowerApps.

I need to get the selected page number in PowerBI, so if i e.g. select "Page 2" in PowerBI, PowerApps should get "page 2" so that a related "screen 2" opens in PowerApps.

How can i get the selected page number in PowerBI (e.g. as value) so that i can pass this information to PowerApps?

On this way, i want to prevent to build 10 different PowerApps for 10 different PowerBI pages. I just want to use 1 PowerApp with 10 different screens.

[MFelix · Accepted solution]

Hi @timtack ,

You cannot get the information for the page in Power BI using DAX, what I suggest is that you create a simple table with the page number (not connected to anything else) then use this has a filter of the page and select the page number, and you can use that field on your Powerapp that way since it's filter on a specific number will return the value for your PowerApp.

Only problem is that if you want to reorder the pages you need to also change this filter.

[timtack]

Hi @MFelix,

i get your approach and it makes sense, thanks for that! I would like to prevent user-related error possibility. With your approach, one possible risk would be e.g. a user is on page 10, but forgot to set the filter on "10" and writes comments into another page's comments field. Have you a suggestions to additionally prevent this? I need to make sure that the page related comments are made correctly

[MFelix]

Hi @timtack ,

I'm nort saying that the user should make a selection of the filter, you should add that filter on that specific page without the user option to change the page, that way the context of the page (that you set previouly) would pass to your power app.

[timtack]

Hi @MFelix ,

my fault! Now i get your point. Thank you very much for your help!