Button to move between pages and applying conflicting slicers

[dario_kaosniter]

Good morning everyone!

I am facing the following issue.

PowerBI description:

I have 1 main dashboard with 13 KPIs (visuals) and multiple sheets with tables which show the data behind the KPIs (for example in the main dashboard we have the sum of sales and in the corresponding sheet I have the list of the sales). In each sheet I have 2 conflicting slicers, meaning they can't be present at the same time in the sheet without editing the interactions

Problem statement:

I would like 2 buttons for each KPI which perform the following actions:

• takes me to the "sales overview" sheet
• activates 1 slicer and deactivate the other one, or at least edit the interaction between the slicers and the table.

Do you have any idea on how to do that?

thank you

Dario

[v-jayw-msft]

Hi @dario_kaosniter ,

For the first requirement, you can check the document about bookmarks.

https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks 

For the second requirement, you can check the documents about interactions and sync-slicer.

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions 

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers#sync-and-use-slicer... 

Hopefully works for you.

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[amitchandak]

@dario_kaosniter , I did not get it completely. But see if bookmarks can help

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive