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.

rohit1991's avatar
rohit1991
Super User
1 year ago

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.