Filter a slicer

[LS69]

Hello im still new i Power Bi. I have a issue regarding showing or hide(outgray) values in a slicer. 

scenario:

I have two slicer where i from table 1 get 

Department A	Office A1,A2
Department B	Office B1,B2
Department C	Office C1;C2

this works fine.

In the other related table(also a slicer) i get values  

LOffice 1,2,3,4,5,6,,,,

What i want to achieve is in the when i choose for example Dep A and Office A1, only get for instance LOffice1 which is related to Dep A and Office A1.  

Right now i get all the values(1,2,3,4,5,6,) from LOffice unregarding if it is related or not. Is there a quick solution to solve this issue.

All i want is to show only related values in LOffice-slicer and it's ok if the other values are hidden or outgrayed or something. 

In Power Pivot there working just fine on the same model.

Regard L

[amitchandak]

@LS69 , Second table needs unpivot based on what I got, and a new column post that.

Power Query Table.Unpivot, Table.UnpivotOtherColumns: https://youtu.be/0FEGEAz9UMw

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.