Forum Discussion

jamie8888's avatar
jamie8888
New Member
1 year ago
Solved

Slicer to filter a table

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.

Need Help
  • johnt75's avatar
    johnt75
    1 year ago

    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.

2 Replies

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    1 year ago

    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.