table issue

[henry24007]

if i have a dataset look like below:

faculty	department	a	b	c
aaa	a1	10	9	8
aaa	a2	7	6	5
bbb	b1	4	3	2

I want to make a table with a faculty slicer, if I select aaa faculty, it will show like below

	a1	a2
a	10	7
b	9	6
c	8	5

if I select bbb faculty, it will show like below:

	b1
a	4
b	3
c	4

is it possible the do this within one table? by power query or other method?

[amitchandak · Accepted solution]

@henry24007 , In power query Unpivot the, column a,b,c then you can use Matrix visual with chose of column on the column of the matrix

Unpivot Data(Power Query) https://www.youtube.com/watch?v=2HjkBtxSM0g&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=11

https://radacad.com/pivot-and-unpivot-with-power-bi