Forum Discussion
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?
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
4 Replies
- Fowmy
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 - vojtechsima
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- vojtechsima
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.
v-henryk-mstfCommunity 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.
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,
HenryIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
