Slicer to filter a table

[jamie8888]

Hi, I have 2 columns in the same table, one called Order No and the other called consignment.

Each consignment can contain multiple orders

I want a slicer to select an order number and then the table would show all of the orders on the consignment that the selected order is on.

So far the table will only show the selected order and not the other orders on that consignment.

I would appretiate any help, thank you.

[jamie8888]

Thanks you, that did it!

[johnt75 · Accepted solution]

Create a new table like

Consignment Slicer =
SUMMARIZE ( 'Table', 'Table'[Order no], 'Table'[Consignment] )

And link this to your existing table in a one-to-many single direction relationship using the consignment column. Then create a slicer using the order number column from the new table.