Visualisation filtering to transfer to other dashboard tabs/pages

[FrenchWrench]

Hi all,

I'm new to the Power BI Desktop and I'm trying to understand how it works with "Northwind" sample database.
The option to click on the visualisation and it filters all diagrams on the dashboard is great, now I'm wondering how can I carry it through to another page of my dashboard.

Is it even possible?

I know that when I add a filter and synchronize it with another page then it's value is the same on both pages. Can I link it to diagram so that when I click on a visualisation it switchess on the filter (that is synchronized)?

Thanks in advance!

[Elena_Kalina · Accepted solution]

Hi @FrenchWrench 

If you mean what you want to click on some value on the visuals in the slice, the selected value should change, then this does not work.

1. Slicers → Visuals:

   • Slicers can filter other visuals (including charts, tables, etc.)

   • This is the standard and expected behavior

2. Visuals → Slicers:

   • Visuals cannot directly filter or change slicer selections

   • This is a technical limitation of Power BI's architecture

What You Can Do Instead

If you need clicking a chart to affect what shows in filters, try these real solutions:

1. The Button Trick

   • Make invisible buttons over your chart sections

   • Each button can set a slicer when clicked

   • Works but takes some setup

2. Use a Fake Slicer

   • Create a table that looks like a slicer

   • It can react to chart clicks

   • Not as pretty but functional

3. Page Navigation

   • When user clicks a chart section

   • Take them to a new page with filters pre-set

   • Simple but breaks the "one-page" feel

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.

[speedramps · Accepted solution]

You can copy and paste slicers onto other pages. Then sync the slicers.

Learn how here https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers?tabs=powerbi-deskt...

You can create a drillthrough page.

For example Page 1 shows totals sales by customer.

You click on a customer and then drillthrough to Page2 which shows all invoices for that customer

Learn how here https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

Please click thumbs up because I have tried to help.
Then click [accept solution] if it works.

You can accept multiple solutions from helpers and it is polite to do so, Thank you.

[Elena_Kalina · Accepted solution]

Hi @FrenchWrench 

If you mean what you want to click on some value on the visuals in the slice, the selected value should change, then this does not work.

1. Slicers → Visuals:

   • Slicers can filter other visuals (including charts, tables, etc.)

   • This is the standard and expected behavior

2. Visuals → Slicers:

   • Visuals cannot directly filter or change slicer selections

   • This is a technical limitation of Power BI's architecture

What You Can Do Instead

If you need clicking a chart to affect what shows in filters, try these real solutions:

1. The Button Trick

   • Make invisible buttons over your chart sections

   • Each button can set a slicer when clicked

   • Works but takes some setup

2. Use a Fake Slicer

   • Create a table that looks like a slicer

   • It can react to chart clicks

   • Not as pretty but functional

3. Page Navigation

   • When user clicks a chart section

   • Take them to a new page with filters pre-set

   • Simple but breaks the "one-page" feel

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.