cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

How to Enable multi select in slicer for dynamic measure change

I have Dataset similar to below

 

Name Assignment1Assignment2Assignment3Assignment4Assignment5Assignment6Assignment7Assignment8
Suj107108101078
Swe898910799
Har9798109810
Rit101010101010910
Hem56578799

 

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.
 
 
 
 

 

2 REPLIES 2
Highlighted
Super User II
Super User II

Re: How to Enable multi select in slicer for dynamic measure change

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)

1.JPG

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)

2.JPG

 

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

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
You can follow me on LinkedIn

Please take a quick glance at newly created report:
My Report
Highlighted
Microsoft
Microsoft

Re: How to Enable multi select in slicer for dynamic measure change

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (731)