Forum Discussion
Filtering matrix columns with dropdown
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?
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.
2 Replies
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.
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.
