Forum Discussion
using two date filters for different columns in the same matrix
Hi all,
I have a matrix visual that has a column for each products sales by customer. I also have a column for the projected sales by customer. on the page I have a FY QTR slicer to slice the sales columns. now the problem I face is the projected sales column cannot be affected by the FY QTR filter on the page, it needs its own filter that will filter just the projected sales column not the other sales columns.
what is the best approch to accomplish this?
| fy filter (only for projected sales) | Fy Filter (only for sales) | |||
| customer | projected sales | Apple sales | Oranges sales | Onion Sales |
| Walmart | 100,000 | 50,000 | 20,000 | 10,000 |
| Winco | 150,000 | 55,000 | 25,000 | 15,000 |
| Fred M. | 200,000 | 60,000 | 30,000 | 20,000 |
Hi Anonymous ,
This doesn't seem to work. The slicers of the same table seem to take the intersection, not the concatenation. Please try to create an idea here and vote for it.
I have also found a similar post, please refer to it to see if it helps you.
how can I have two column with different slicer?
If I have misunderstood your meaning, please provide your desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Anonymous ,
This doesn't seem to work. The slicers of the same table seem to take the intersection, not the concatenation. Please try to create an idea here and vote for it.
I have also found a similar post, please refer to it to see if it helps you.
how can I have two column with different slicer?
If I have misunderstood your meaning, please provide your desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.