How to Enable multi select in slicer for dynamic measure change

[Harinihemanth06]

I have Dataset similar to below

Name	Assignment1	Assignment2	Assignment3	Assignment4	Assignment5	Assignment6	Assignment7	Assignment8
Suj	10	7	10	8	10	10	7	8
Swe	8	9	8	9	10	7	9	9
Har	9	7	9	8	10	9	8	10
Rit	10	10	10	10	10	10	9	10
Hem	5	6	5	7	8	7	9	9

And have created disconnected table with measure names for Dynamic visual change

And have written dax 

Delops =

VAR MySelection =

SELECTEDVALUE( Sheet2[Assignment] )

RETURN

SWITCH (

TRUE (),

MySelection = "Assignment1",SUM(Sheet1[Assignment1]),

:

MySelection = "Assignment8",SUM(Sheet1[Assignment8]),Blank())

With above dax am able to perform only single selection in Slicer if multiple are selected blank is dispalyed.

And if I use multiple measures by using "IF (contains)"to achive multi slicer select I wount be able to drag Legend in to visual.

Need help with it as unpivoting and above solutions are not working.

[Tahreem24]

HI @Harinihemanth06 ,

I recommend you to unpivot all your assignment 1 to assignment n and then use this into filter with multiple selection. Follow the below step to solve your issue:

Step 1: Go to Query Editor and select all assignments columns(say 1 to n) --> go to trnasform tab --> select unpivout column (attached screen shot below)

Step 2: Rename the Attribute column to Assignment Name. Close and Apply.

Step 3: Take the Assignment name into Slicer and enable multi select option. (SCreen shot is attached below)

Don't forget to hit THUMBS UP and Accept this as a solution if it helps you!

[Harinihemanth06]

@Tahreem24 Thanks for your valuable input since the data volume is huge un-Pivoting is not a best option.

I have chosen to go with multiple measures for the requirement.