Filter the visual using a column based on some selected value from slicer using different column

[Anonymous]

Column A	Column B	Column C	Column D
A	A1	A2	DATAFLOWID1
B	AB1	B1	DATAFLOWID1
C	T	T	DATAFLOWID1
D	D	AD	DATAFLOWID2
E	AE	AE3	DATAFLOWID2
F	O	O	DATAFLOWID3

I have a data like this and i want to use a slicer from field "Column A", based on the selected value from the slicer i want to evluate a condition like, if that selected value is present in either of "Column B" or "Column C" then fetch the "Column D" value and filter he visual using those "Column D values".
For example if the selected value is "A"  and the "Column D" values which satisfies he condition mentioned above are "DATAFLOWID1" and "DATAFLOWID2". filter the visual based on these values and output will okk like this

Column A	Column B	Column C	Column D
A	A1	A2	DATAFLOWID1
B	AB1	B1	DATAFLOWID1
C	T	T	DATAFLOWID1
D	D	AD	DATAFLOWID2
E	AE	AE3	DATAFLOWID2

Any solution is welcome and thanks in advance.

[v-shex-msft · Accepted solution]

HI @Anonymous,

Unforgettable, power bi slicer not able to achieve your requirements based on current table structures.
I think you need to unpivot your fields n on query editors side and convert your fields to attribute and value, then you can create a slicer with attribute fields value to choose which field displayed on your chart:

Dynamic Attributes In A Power BI Report 
Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous , you can unpivot and try

https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/

[Anonymous]

sorry, i didnt get your point. how will the unpivot will be of a help here?