How do I select muliple values in slicer when using selectvalue?

[Anonymous]

I am currently making muliple markers with shapes depending on which year you select in a slicer, these markers are transparant until selected but if i select multiple years it stops working (Since selectvalue only understand one value). How can i make them adapt to multiple selection? Current code that works for each year:

2008 Make Transparent =

      IF(

         SELECTEDVALUE(Data[Year])=2008, 

         "#2071B5", 

         "#FFFFFF00" 

      )

[AlphaBravo · Accepted solution]

Hi, Vinn 👋

The issue you're facing is due to the SELECTEDVALUE function. It returns a single selected value when a single value is selected in a slicer. If you have multiple values selected, it returns a blank.

Try using the following DAX:

2008 Make Transparent =
    IF(
        CONTAINS(ALLSELECTED(Data[Year]), [Year], 2008),
        "#2071B5",
        "#FFFFFF00"
    )

Make sure to replace Data[Year] with the corresponding Table and Column of your data.