Slicer for multiple measure selection on clustered chart

[Anonymous]

Hi all, 

I'm looking to create a line and column clustered chart where a user can include and exclude certain measures based off of a slicer. The user would also need to be able to select multiple measures at once. I've made some progress but have run into some problems. Here are the details:

I created a table to house the slicer names for each measure, a "Measure Dimensions" table. Here's an example of the the variable/measure names included in that table:

Volume1

Volume2

Volume3

Cost1

Cost2

Cost3

I have already created a calculated measure for each of the above variables. Then, I created a measure for the clustered chart itself:

Volume 1 Selection Measure =

VAR MySelection =

SELECTEDVALUE('Measure Dimensions'[Measure],"Volume1")

RETURN

SWITCH(

TRUE(),

MySelection = "Volume1 Dataset",[Volume1 Calculated Measure],

blank())

I created a measure like the one above for each variable. I am able to select one variable just fine. However, if I try to select multiple variables from my slicer, the chart defaults to including all of the variables in the chart, instead of just the ones I selected from the slicer. How do I fix this?

[Anonymous · Accepted solution]

I found a solution here: https://www.youtube.com/watch?v=OIGGrrnMIgk

I'll leave this topic up in case anyone needs this in the future. 

[Dave_de_Castro]

Thanks KAS634 - this video is exactly what I was looking for 

[wdx223_Daniel]

 

[wdx223_Daniel]

maybe this is the job of calculation group

[Anonymous]

Hi Daniel, I'm not too sure I follow? I should add that the visual appears to work fine with just the cost measures. It starts to have issues when I add the volume measures.