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:

Using Apps Using Formulas

All responses (3)

Answers (0)

WC-23102228-0 2 on at

Like (0)

Report

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

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");
Suggested answer

Nandit 1,563 Super User 2025 Season 1 on at

Like (0)

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

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!
ronaldwalcott 3,128 on at

Like (0)

Report

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

Your query is not displaying properly. Please restate it.