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 ...
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.

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.