Control Power BI page filter via PowerApps

[phth017]

Hi

I have created a Power BI report connected to SharePoint list, it works as a logbook to record the date,item and quantity of certain item withdrawn or return to inventory. At every month end (not necessarily on last day of the month, could be one or two days before), I would need to generate the month end report and refresh the opening balance to say 60. I have inserted the page filter such that the report only display the records in this month. But what I need to achieve is to set the page filter to display all records from certain onwards. Understand that Power BI does not have button that could update the measure, therefore I was thinking if there's a way to pass a parameter from PowerApps to a measure in Power BI. Ultimately, where the user click the button on certain date, the page should refresh the opening balance to 60 and only display the records from the date onwards.

Does anyone have any idea on how to achieve this ?

[v-juanli-msft]

Hi @phth017 

"But what I need to achieve is to set the page filter to display all records from certain onwards",

What does "all records from certain onwards" mean?

"therefore I was thinking if there's a way to pass a parameter from PowerApps to a measure in Power BI"

Do you use powerapps visual in power bi and want to use the powerapp visual to filter other visuals in power bi?

"Ultimately, where the user click the button on certain date, the page should refresh the opening balance to 60 and only display the records from the date onwards"

Sorry, i don' understand what you finally want.

Please share some example of your requirement.

Best Regards

Maggie