Forum Discussion
How to apply a filter only for rows at a matrix visualization
I need a filter that is only applied to the rows, but not to the columns of a matrix. It's possible?
- Anonymous4 years ago
For example, I have this table without any filter applied:
And with a normal filter, it will only appear the products which has a client with an amount in the "Risk" segment:
But, what I need is that only Clients to be filtered and see all the products available. Like this:
It is for a white space analysis, to see which products are not sold to the clientes of certain industries or segments.
- Anonymous4 years ago
Hi Anonymous ,
Here's my solution.
Sample data
1.Create a calculated table to get the Product Number.
2.Create a measure to return the results.
Measure = IF(MAX('Table'[Product]) in ALLSELECTED('Table 2'[Product]),SUM('Table'[Value]),0)3.The matrix is created by the [Clients], [Product] in the main table measure. The slicer is created by the [Product]
in the new calculated table.
When the slicer is filtered, all product numbers still exist.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- davehus
Memorable Member
Hi Anonymous ,
Can you provide an example of what you want to achieve?
Thanks,
- AnonymousNot applicable
For example, I have this table without any filter applied:
And with a normal filter, it will only appear the products which has a client with an amount in the "Risk" segment:
But, what I need is that only Clients to be filtered and see all the products available. Like this:
It is for a white space analysis, to see which products are not sold to the clientes of certain industries or segments.
- AnonymousNot applicable
Hi Anonymous ,
Here's my solution.
Sample data
1.Create a calculated table to get the Product Number.
2.Create a measure to return the results.
Measure = IF(MAX('Table'[Product]) in ALLSELECTED('Table 2'[Product]),SUM('Table'[Value]),0)3.The matrix is created by the [Clients], [Product] in the main table measure. The slicer is created by the [Product]
in the new calculated table.
When the slicer is filtered, all product numbers still exist.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AnonymousNot applicable
Thanks very much! It works perfectly. Only one doubt, is it possible to put a conditional in that measure?