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

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.