Forum Discussion

WackyJackie's avatar
WackyJackie
New Member
2 years ago
Solved

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 ProductA
  
  
Current Product 
B10
20
D10

 

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? 

  • Anonymous's avatar
    Anonymous
    2 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 Chang

     

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

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not 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 Chang

     

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