Filtering matrix columns with dropdown

[314mp_M0th4]

Hello, this is not as simple as it sounds. Lets say I have data :

Type	Value
a	5
a	20
b	15
b	10
c	15
c	30

And I want a matrix like this :

Type 1	Type 2
value	value
value	value

Where the types columns are linked to a dropdown where you can select a, b or c.

Is this possible?

[v-jianboli-msft · Accepted solution]

Hi @314mp_M0th4 ,

If you want to create a matrix visual that do not aggregate your data, you need to add an column for row field:

Output:

Best Regards,

Jianbo Li

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

[314mp_M0th4]

Thanks! I also found that I am a dummy and by using basic filtering on page from the filtering pane you get the same result as using a dropdown.