This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
Hi All,
I have been working on a personal exercise in the Power BI desktop, using buttons and bookmarks to switch between charts and tables (refer to the image below).
Let us consider the first visual from the left (Category breakdown), I'm able to set up bookmarks and switch between Visual and Tabular buttons only with the following bookmark's properties,
And, when I switch between the bookmarks buttons the other visuals in the report are changing.
In order to detach the interaction, I unchecked the All visuals and checked Selected visuals. When I do so, the bookmarks are not functioning.
Could you please help me with this issue, so that when I switch between the buttons under the three visuals (Category breakdown, Store breakdown, Variation of Net Sales), it reflects only in the specific visual?
For example; When I switch between the buttons in the visual Category breakdown, only the visuals in this section should change. And, when I switch between the button in Store breakdown, only the visuals in this section should change and the other visuals shouldn't interact.
Looking forward to your help, many thanks in advance!
Cheers!
Solved! Go to Solution.
@p_rathinavel
Before you tick "Selected Visuals", make sure you have selected all the relevant objects in the Selection Pane. For example: To set up for the Category Breakdown charts, select the Chart, Table and the two buttons then update the bookmark.
The point is, if you are applying "Selected Visuals", you need to select those visuals in the selection pane.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@p_rathinavel
Before you tick "Selected Visuals", make sure you have selected all the relevant objects in the Selection Pane. For example: To set up for the Category Breakdown charts, select the Chart, Table and the two buttons then update the bookmark.
The point is, if you are applying "Selected Visuals", you need to select those visuals in the selection pane.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Glad it worked!
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 33 | |
| 26 | |
| 21 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 63 | |
| 43 | |
| 28 | |
| 24 | |
| 22 |