Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

Slicer for multiple measure selection on clustered chart

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?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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. 

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

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. 

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

 

wdx223_Daniel
Super User
Super User

sample.gif

wdx223_Daniel
Super User
Super User

maybe this is the job of calculation group

Anonymous
Not applicable

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.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.