Dynamically change the field in a table based on filter selection

Question

Hi All,I have these 2 tables in my PBI model&nbsp;Table 1&nbsp;&nbsp;&nbsp;&nbsp;Table 2booktopic 1topic 2topic 3&nbsp;topicbook 1aaa 1bbb 1&nbsp;&nbsp;topic 1book 2aaa 2&nbsp;ccc 2&nbsp;topic 2book 3&nbsp;bbb 3ccc 3&nbsp;topic 3book 4aaa 4bbb 4&nbsp;&nbsp;&nbsp;book 5aaa 5&nbsp;ccc 5&nbsp;&nbsp;&nbsp;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?&nbsp;Thank you in advance.

ddpl · Accepted Answer

nemo&nbsp;,&nbsp;First you need to unpivot Table 1,&nbsp;After that you can create a matrix and you can slice it as you requested...&nbsp;

Forum Discussion

Dynamically change the field in a table based on filter selection

1 Reply

Related content

Dynamic Status Change for events based on selected date range

Dynamic change of Default Slicer selection

Dynamic images based on selections

Change in category selection changes selected subcategory in slicers

Dynamic Filtering based on date selection

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