Forum Discussion

Alessandro70's avatar
Alessandro70
Regular Visitor
1 year ago
Solved

Table visual filtering

Hi all,   i have one table coming from xls file and i'm working with 2 visuals: 1 Table and 1 Slicer If i filter the slices i can see the table filter but it doesn't work vice versa   It is appr...
Need Help
  • v-karpurapud's avatar
    v-karpurapud
    1 year ago

    Hi Alessandro70 

    Thank you for contacting the Microsoft Fabric Community Forum.

    In Power BI, slicers act as filter input controls, allowing you to filter tables and other visuals. However, the reverse isn’t possible tables or other visuals cannot filter slicers. This is by design and follows Power BI’s current interaction model. The “Edit interactions” feature lets visuals affect each other, but it does not allow visuals to change slicers, which can limit dynamic reporting options where more bidirectional control is desired.

    If you need visuals to dynamically influence slicer options, it’s a good idea to submit this as a feature request in the Power BI Ideas forum, as MasonMA  suggested.


    Regards,
    Karpurapu D,
    Microsoft Fabric Community Support Team.

burakkaragoz's avatar
burakkaragoz
Super User
1 year ago

Hi Alessandro70 ,

 

This happens all the time - super annoying when you expect it to work both ways.

Most likely culprit: Your visual interactions are set wrong. Here's what to check:

  • Click on your table visual
  • Hit "Edit interactions" in the ribbon
  • Look above your slicer - you should see a "Filter" icon, not "None"

If that doesn't work: Sometimes Power BI blocks cross-filtering from tables, especially if your Excel data has duplicates or messy relationships. It's trying to "protect" you from confusing results.

Quick test: Try clicking on a row in your table. Does anything happen to other visuals on the page? If nothing happens, then cross-filtering is definitely disabled.

Alternative fix: Instead of fighting with the table, just use two slicers. Sometimes that's actually cleaner for users anyway - they don't have to figure out that clicking the table does something.

What kind of data is in your Excel file? If it's got duplicate entries or complex relationships, that might explain why Power BI is being stubborn about the cross-filtering.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was assisted by AI for translation and formatting purposes.