Selected value with more than one slicer

[Anonymous]

Hello,
I have the following point:

There are 2 slicers on the same report:
=> One is to select unique value for the product number. This selection will bring the price (measure) of that product.

=> The second slicer is to select a list of products (same column from the previous one) with their respective prices, but I need to bring the price of the first selection (above) as the baseline to compare with the prices of the products selected in the second slicer. This should be shown in a matrix.

Any thoughts on it?

Thank you.

[amitchandak]

@Anonymous , you can not have a slicer on measure.

If the two slicers are on the same table they should filter each other.

else measure from the common fact can be used as a visual level filter to filter the data

https://www.youtube.com/watch?v=cyOquvfhzNM

[Anonymous]

Hi @amitchandak 

Thanks for the reply. I mentioned the measure just to emphasize that the price of the product is a measure. The main point for me here is how to get the price from the product selected in the first slice to be in a column in matrix so that I could calculate the variation of the other products vs this price. 

Thanks for the video shared.