Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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?
Solved! Go to Solution.
@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
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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.
Click the button to make the jump
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.
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:
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.
@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
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group