Change visible property of imbedded Power BI report based on default, button 1 or button 2

(0) Share

Report

Posted on by WC-23102228-0

I have a Power App that contains multiple imbedded Power BI reports. The problem is that they will not load unless they are visible. They only have to load one

time during a user session. After that, you can click on and off them and they will still show when needed.

I have placed them all in one vertical container. There are buttons to the left of the container used to toggle between each report.

The button OnSelect property is

Set(varShowReport, "Dashboard") with the text between quotes being the name of the report
 
The report visible property is 
varShowReport="Dashboard") 
 
This works perfectly. The visible report changes based on which report button I click. 
 
However, the user currently has to click each button to get each report to load. They can click them each quickly and all 
reports will load at the same time but that is tacky. I don't want to have to add a text box with instructions telling the 
user to click each button to trigger the reports to load. 
 
Ultimately I need all reports to be visible when the screen opens, then only visible based on the button clicked, otherwise
not visible. 
 
I am thinking this will require a additional variable in the screen OnStart, and an if statement in the report Visible
property, but I cannot figure out how to get that to work.
 
Any suggestions?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

ronaldwalcott 3,862 Moderator on at

Like (0)

Report
Copy link

Link copied!

Your query is not displaying properly. Please restate it.

Was this reply helpful? Yes No
Suggested answer

Nandit 1,568 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi WC-23102228-0,

Great that you already have the toggle functionality developed. Assuming your reports are on top of each other. Can you try to use your Set code on the OnVisible property of the screen:

Set(varShowReport, "Dashboard")

So when you open the app, both reports load, but when you navigate to the screen, you will see the one you have set as default. This might help you get around this issue. Let me know how it goes.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
WC-23102228-0 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Nadit,

I tried that, but the approach of Set(varShowReport, "Dashboard") is used to specify that specific report to open. To do this the code would be:

Set(varShowReport, "Dashboard");

Set(varShowReport, "Report1");

Set(varShowReport, "Report2");

This set of commands won't show all, only the last listed. I had hoped it would temporarily open each report as Power Apps cycles through the command for each report, but it did not work.

I also tried this in the OnVisible of the screen and the corresponding code for the buttons and reports but it did not work:

Set(varDashboard, "Dashboard");

Set(varReport1, "Report1");

Set(varReport2, "Report2");

Was this reply helpful? Yes No