Sync Exclusions from Matrix and Table Visuals

[Han_Solo]

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.  

[danextian · Accepted solution]

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 · Accepted solution]

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

[danextian · Accepted solution]

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.