Forum Discussion

mithiladas02's avatar
mithiladas02
Icon for Helper I rankHelper I
4 years ago
Solved

How to i select multiple items in slicer

Hi,

 

i am using the below dax for slicer. But i am not able to select multiple items at a time. It is showing only 1 like A or B or C. how can i select A,B,C at a time. In formating i select miltiple selection also but didnt work. 

 

2,"A", [Measure 1],

3,"B", [Measure 2],

4,"C", [Measure 3],

5, "D", [Measure 4],

1, "None"

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi mithiladas02 ,

     

    You could use selectedmeasurename() function.

    Create a slicer table contains the measure names you are using and add the below part of formula to the measures.

    IF(SELECTEDMEASURENAME() in VALUES(slicer[slicer]).

    For example:

     

    _avg = IF(SELECTEDMEASURENAME() in VALUES(slicer[slicer]), AVERAGE('Table'[value]))

_max = IF(SELECTEDMEASURENAME() in VALUES(slicer[slicer]), MAX('Table'[value]))

_min = IF(SELECTEDMEASURENAME() in VALUES(slicer[slicer]), MIN('Table'[value]))

_sum = IF(SELECTEDMEASURENAME() in VALUES(slicer[slicer]), SUM('Table'[value]))

     

     

    Best Regards,

    Jay

3 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi mithiladas02 ,
    You don't give us enough information to solve this, but have you tried CTRL key along with your choices?


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel

    • mithiladas02's avatar
      mithiladas02
      Icon for Helper I rankHelper I
      4 years ago

      Yes i tried. i made a dynamic line chart where i have created measure for slicer. on this measure i am not able to select multiple item to show the compare in line chart.  

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi mithiladas02 ,

     

    You could use selectedmeasurename() function.

    Create a slicer table contains the measure names you are using and add the below part of formula to the measures.

    IF(SELECTEDMEASURENAME() in VALUES(slicer[slicer]).

    For example:

     

    _avg = IF(SELECTEDMEASURENAME() in VALUES(slicer[slicer]), AVERAGE('Table'[value]))

_max = IF(SELECTEDMEASURENAME() in VALUES(slicer[slicer]), MAX('Table'[value]))

_min = IF(SELECTEDMEASURENAME() in VALUES(slicer[slicer]), MIN('Table'[value]))

_sum = IF(SELECTEDMEASURENAME() in VALUES(slicer[slicer]), SUM('Table'[value]))

     

     

    Best Regards,

    Jay