return values in a column based on a slicer

[Misguidedghost_]

Hello everyone; 

I am a beginner in Power BI and need help with a measure. 

So I have a table of this type : 

General ID	Specifid ID	Product Type
A201	ATA01	Hair
B206	BTA06	Skin
A201	ATA02	Eye
C202	BTA02	Lips

I need to create a table that will return values depending on a slicer on my General ID. So if my slicer is on A201, I need to return : 

Specifid ID	Product Type
ATA01	Hair
ATA02	Eye

I already created a diconnect table with only values of my  General Id column to turn it into a slicer, but then i can't find the measure - using selectedvalue - to return the right values in Specific ID and Product Type columns. 

Can you please help me please ? 

Regards 

[Shaurya · Accepted solution]

Hi @Misguidedghost_,

No need to create any additional table. Your work can be done by using just a slicer and a table visual. Insert a table visual and pull in Specified ID and Product Type as columns in it. Then add a slicer and use General ID in it.

Result:

Works for you? Mark this post as a solution if it does!

[Misguidedghost_]

Hello @Shaurya 

Thank you for your response, it works verry well ! 

Have a good day