Table visual filtering

[Alessandro70]

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 appreciated any help

Alessandro

[v-karpurapud · Accepted solution]

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.

[Alessandro70]

I have already tried what you suggested but i have no solved.

Attached the screenshot of setting and you can see not all the Slicer have the interactions icon and those have it dont work

[MasonMA]

@Alessandro70 

What would you mean when you mention 'Table Filter' in your first message? Did you want to use your 'table' to filter your 'Text Slicer'? 

If this is what you meant, then Power BI uses a one-way interaction flow, not the other way around:) 

[Alessandro70]

Yes i want to use a table to filter slicer

[MasonMA]

Hello @Alessandro70 

How about to consider voting this as a new idea for Microsoft. This one below is from a user that has similar request as yours. 

https://community.fabric.microsoft.com/t5/Fabric-Ideas/Enable-Visuals-to-filter-the-options-in-the-S...

[rohit1991]

Hi @Alessandro70 ,

Slicers are meant to filter other visuals (like tables and charts), but you can’t have a table visual filter or control a slicer. There’s no setting or DAX formula to make the filter flow in reverse slicers only work in one direction.

If you want your table to cross-filter other visuals, you can use the "Edit interactions" option, but the slicer itself can’t be changed by clicking a table value. This is just how Power BI’s filter logic works right now.

If your visuals aren’t interacting as expected, double-check your interactions:

• Click on your visual, then go to the Format tab and select "Edit interactions" to control how visuals affect each other.
  
  

• Remember, though, a slicer can’t be filtered by another visual.

[burakkaragoz]

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.

[MasonMA]

Hello @Alessandro70 

If your visuals are on the same page, I'd suggest double checking your 'cross-filtering or highlighting' by clicking on your table visual and going to 'Format pane', then 'Edit interactions'

There you can control how visuals interact with each other.

However, a slicer cannot be changed by other visuals, which is s a limitation by design.

Hope this helps:)