Forum Discussion
Use selected value as filter on side bar
Hi all
I have a table with previous product and current product. The page is set up to look at the visuals from a current product selection which I have created a slicer for. This shows what the previous product was for the selected product in the slicer.
However, I am trying to also show the current product if the previous product was equal to the selected product. In other words, I am trying to show something as follows:
| Selected Product | A |
| Current Product | |
| B | 10 |
| C | 20 |
| D | 10 |
The issue is that because I have selected the current product as Product A, the matrix only shows that specific product and not the others. I have created a measure for the count with a REMOVEFILTER, but the product name is still not showing. How can I get this to display properly?
- Anonymous2 years ago
Hi WackyJackie ,
I made simple samples and you can check the results below:
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
- AnonymousNot applicable
Hi WackyJackie ,
I made simple samples and you can check the results below:
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.