Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
FrenchWrench
New Member

Visualisation filtering to transfer to other dashboard tabs/pages

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!

2 ACCEPTED SOLUTIONS
Elena_Kalina
Solution Sage
Solution Sage

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.

View solution in original post

speedramps
Super User
Super User

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.

View solution in original post

2 REPLIES 2
speedramps
Super User
Super User

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
Solution Sage
Solution Sage

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.

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.