Slicer to filter columns

[Anonymous]

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.

How can I use the field 'Branch' in the 'Common Fields' table to filter the 'Total stock' field in the '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.

This Power BI report is fairly expansive, but I have stripped back the contents of it for the purpose of this query.

Many thanks for your time, support & assistance.

https://1drv.ms/u/s!AlGraWJniC_whoA4TxMHYxF2UGG6Gw?e=kJWMM0 

[YJ · Accepted solution]

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.

That said i am new here and still learning too.

Good luck,

regards

SK

[Anonymous]

Thanks @YJ . I was unaware of the unpivot function - your advice really helped.

Best Regards.