Dynamically change the field in a table based on filter selection

[nemo]

Hi All,

I have these 2 tables in my PBI model

Table 1					Table 2
book	topic 1	topic 2	topic 3		topic
book 1	aaa 1	bbb 1			topic 1
book 2	aaa 2		ccc 2		topic 2
book 3		bbb 3	ccc 3		topic 3
book 4	aaa 4	bbb 4
book 5	aaa 5		ccc 5

Is it posisible to use the column topic of Table 2 as a filter and depending on its selection, a correspoding columns (topic 1, topic 2 or topic 3) would be displayed in a table like this?

That is, if I selected topic 3 in the filter, the visual would look like this? 

Thank you in advance.

[ddpl · Accepted solution]

@nemo ,

First you need to unpivot Table 1,

After that you can create a matrix and you can slice it as you requested...