Use selected value as filter on side bar

[WackyJackie]

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? 

[v-tianyich-msft · Accepted solution]

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.