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 s...
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.

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.