Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
beamguerreiro
New Member

Change visuals, by single click on a button

Hello, 

 

I would like to create a full report in a single sheet, where I would have (e.g.) 6 buttons/text boxes. 

 

By clicking in each one of these buttons, I would expect my visuals will change accordingly. For example:

 

If click on box A, the visuals in the sheet will update with information on A.

If click on box B, the visuals in the sheet will update with information on B.

etc... 

 

The main goal is to avoid to go over multiple sheets, in a single reports.

 

Can you help me to find a solution?

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@beamguerreiro 

You can use Bookmarks in Power BI to achieve this, please refer to these videos: 
https://www.youtube.com/watch?v=xCMqWEvSkAs&list=PLv2BtOtLblH1IJqcqSuMTyvEi7W-laWti


Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

4 REPLIES 4
v-henryk-mstf
Community Support
Community Support

Hi @beamguerreiro ,

 

I think the best way is to create a button on each page to jump from page to page to show different visual effects. I've done a test and the reference is as follows.

vhenrykmstf_0-1636100605864.png

vhenrykmstf_1-1636100624599.png

Click the button to make the jump

vhenrykmstf_2-1636100671760.png

vhenrykmstf_3-1636100688674.png

 

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

vojtechsima
Super User
Super User

Hello, @beamguerreiro,
you can create an individual page for every outcome, but make it Hidden, and on the main page, create buttons that would refer to the hidden page, that way you will be forwarded to the new page, however, the user won'T notice anything. The key is to make the layout look the same.
Or you can use bookmarks:
https://docs.microsoft.com/cs-cz/power-bi/create-reports/desktop-bookmarks

Something like this:

 

vojtechsima_0-1635860536057.png

 

The button position will be the same, but each will refer to a different page. When you are on page 1, you set the "A" to NONE, B = PAge 2, C = PAge 3.
When you are on PAge 2, A = Page 1, B=none, C=PAge 3 etc.

Fowmy
Super User
Super User

@beamguerreiro 

You can use Bookmarks in Power BI to achieve this, please refer to these videos: 
https://www.youtube.com/watch?v=xCMqWEvSkAs&list=PLv2BtOtLblH1IJqcqSuMTyvEi7W-laWti


Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors