Cross Filtering to Limit Slicer Entries

Power BI
6

@GrantR ,

I was working on this at the same time as @Rajesh and came to the same conclusion he did. You can get the effect you want if you change the donut chart to a slicer or the customer slicer to a table (two slicers cross filtering each other or two visuals, but not one visual and one slicer.

I actually tried to force the latter using the measure below in the visual level filter pane of the slicer, and it still didn’t work.

Selected Values = 
VAR SelAreas =
VALUES( Customers[Area] )

VAR Vtable =
FILTER(
    ALL(Customers ),
     Customers[Area] IN SelAreas
)

VAR InTable =
IF(
    SELECTEDVALUE( Customers[Name] ) IN SELECTCOLUMNS( Vtable, "@Name", [Name] ),
    1,
    0
)

VAR AreaList = 
CONCATENATEX( SelAreas, Customers[Area], ", ", Customers[Area], ASC )

RETURN InTable

I’ve attached my test file below if you want to play with it further. I hope this is helpful.

– Brian

eDNA Forum - Slicer (1) Solution.pbix (33.5 KB)

1 Like