Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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

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" 
      )
Need Help
  • AlphaBravo's avatar
    AlphaBravo
    2 years ago

    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.

1 Reply

  • AlphaBravo's avatar
    AlphaBravo
    New Member
    2 years ago

    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.