Filter/Display the "column headers" of Table1 based on the rows of other table "Table2[column]"

[code4578]

Hello. Thanks to this awesome community, I was able to find certain solutions. Unfortunately - until now. 

I have 2 tables Table1 and Table 2. I am looking display/filter only the columns of Table1 based on the rows/values of Table2[columnName]. 

The values of Table1[Name] and Table2[NAME] are same. The Column Headers of Table1 are the values of Table2[columnName]. 

On the visuals, I have a slicer of Table2[columnName]. I want to display specific column Names of Table1 based on the selection from the slicer. 

I tried unpivot column - this works but I have more than million rows from Table1 and it would be nice to remain in the form of Table1. The reason is from the Table1[Name] - we would able to identify the lines based on the Names. So I am looking apart from unpivot. 

Also please note - the column headers of Table1, contain any data form. 

Table1
Name	A	B	C	D	E
Name1	text	Number	text	Number	text
Name1	Number	Date	Number	Date	Number
Name2	Date	text	Date	text	Date
Name2	1.6	Decimal	Decimal	2.8	Decimal
Name3	text	text	text	text	text
etc

Table2
columnName	NAME
A	Name1
B	Name1
C	Name3
D	Name3
E	Name2

Many thanks as always . 

Regards 

[code4578]

Hi Liu, 

Many thanks for your reply. This solution gave me the idea. Unfortunately I have few set backs,

1. Duplicated Values - I have numerous values that are duplicated in Table2[columnName] and hence I encountered the error - of duplicated values (it says this is not allowed for many to one relationship or for columns that are used as the primary key of a table)
2. The values of Table2[columnName] ; (A, B, C etc...) - I have too many values; that is, about 937 values/rows. So, in Table1 - about 937 columns and with more than 2 million rows. 

Thanks for your patience. look forward your thoughts in this regard. 

Regards 

[v-yangliu-msft]

Hi  @code4578 ,

Here are the steps you can follow：

1. Modeling – New parameter -- Fields.

Select Table1 [A], [B], [C], [D] , [E]

2. Joining two tables to each other.

3. Use Table2 [Name] as slicer

4. Place Parameter Table[Parameter Table] and Table1[Name] into it.

5. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly