Forum Discussion

Han_Solo's avatar
Han_Solo
Regular Visitor
1 year ago
Solved

Sync Exclusions from Matrix and Table Visuals

Hi Everyone

 

I have a Table and Matrix visiual on the same report page. Is there any way to exclude an entry by right clicking and excluding on the table and reflecting the same exclusion on the matrix and vice versa. I have slicers synced accross both visuals, but would like the user to be able to exclude specific items by right clicking. Any help would be appreciated.  

Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi Han_Solo 

     

    I don't think it  is currenlty possible to sync inclusion/exclusion across different visuals. Currently, the only option available is for drilldown. You wil need to use a slicer to exlude what needs to be excluded.

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Han_Solo ,


    This kind of excluding is equal to add a visual level filter.

    For example, if you excluded ID C, a filter named "Excluded (1)" will be added into the visual level filters.

    Reference:

    Include and exclude filters - Types of filters in Power BI reports - Power BI | Microsoft Learn

     

    So agree with danextian.

    You can use the slicer to fitler both visuals.

    In addition, you can add filters to the page level filters or the all pages level filters to filter. These two level filters will affect both visuals.

     

     

    Best Regards,
    Stephen Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

2 Replies

  • danextian's avatar
    danextian
    Super User
    1 year ago

    Hi Han_Solo 

     

    I don't think it  is currenlty possible to sync inclusion/exclusion across different visuals. Currently, the only option available is for drilldown. You wil need to use a slicer to exlude what needs to be excluded.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Han_Solo ,


    This kind of excluding is equal to add a visual level filter.

    For example, if you excluded ID C, a filter named "Excluded (1)" will be added into the visual level filters.

    Reference:

    Include and exclude filters - Types of filters in Power BI reports - Power BI | Microsoft Learn

     

    So agree with danextian.

    You can use the slicer to fitler both visuals.

    In addition, you can add filters to the page level filters or the all pages level filters to filter. These two level filters will affect both visuals.

     

     

    Best Regards,
    Stephen Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly