Slicer to filter columns

Question

Hi,I'm looking for some assistance to create a slicer. To help with this, please see the link below for my Power BI file.&nbsp;How can I use the field 'Branch' in the 'Common Fields' table to filter the 'Total stock' field in the&nbsp;'MERGED Master Order Forms' table? The 'Total stock' field is a column created by adding the contents of multiple other columns.I'm conscious this would need a relationship between the two tables, but I don't know how to do this to filter the 'Total stock' field, as it's made up from numerous columns.&nbsp;This Power BI report is fairly expansive, but I have stripped back the contents of it for the purpose of this query.&nbsp;Many thanks for your time, support &amp; assistance.&nbsp;https://1drv.ms/u/s!AlGraWJniC_whoA4TxMHYxF2UGG6Gw?e=kJWMM0&nbsp;&nbsp;

yj · Accepted Answer

Hi,I downloaded your file and not able to see any data , prehaps it is in direct querry mode and not import.My primary guess from what you have written without seeing the data is that you have to make a unpivot and put all your countries into an column , from there you can form your relationship and add the slicer.&nbsp;That said i am new here and still learning too.&nbsp;Good luck,regardsSK

Forum Discussion

Slicer to filter columns

2 Replies

Related content

Slicer for filtering several columns

Time Filter Slicer

Single Slicer to Filter Multiple Columns

Filter data using slicer

Slicer Filtering Another slicer