Need help with measure to get the filter value

[JacoMathew]

Hi All,

 I have a simple a slicer with list of Products and 2 Bar charts with Products and total quantity. I have turned off the interaction between the Product slicer and one of the bar chart. My requirement is to give a different colour to the slicer selected product in the barchart. I was thinking of writing a measure that would give a different Hex code if the Product in the bar chart is same as the selected value in the slicer. But I can't seem to get it to work.

I wrote this measure to get the slicer selected value in the barchart (as a tooltip) but doesn't give the correct value.

Filter selected =

CALCULATE(

    MIN('Table'[product]),

    ALLSELECTED('Table'[product])

)

I also tried selectedvalue() instead of Min() but got blank result.

Please suggest a correct measure that would let me get the slicer selected product in the Product by quantity barchart.

Thanks

Jaco

[JacoMathew]

Thank you @ThxAlot @Ahmedx for the suggestion. I was aware that a separate dimension could be a possible solution, I was more curious on why the ALLSELECTED() wasn't working. Per my understanding, ALLSELECTED() should have retained the Product from the slicer (external of visual) but ignore the row level filter of Product from the visual.

Please note that my model had interaction turned off between the slicer and the bottom barchat. @ThxAlot If I do this in your setup, then the colouring fails.

Any idea why the measure that I had written in the post is failing ?

Thanks,

Jaco

[Ahmedx]

read about Auto Exist

[ThxAlot · Accepted solution]

color.pbix

[Ahmedx]

you have to create a separate dimension table for the slicer,
and only then will you succeed

DimProduct= DISTINCT(Table'[product])