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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
pbiq
New Member

MULTIPLE dynamic measures in visual based on slicer

Hello,

I know how to create a dynamic measure using SWITCH. However, with the method I'm using I can only show one measure at a time. I would like the give the user the capability of selecting multiple measures from a slicer and show them in a visual.

 

For example, if the user makes the following selection:

 

Multiple Selection.png

 

The visual should show as follows:


Visual with multiple measures.png

Here's the PBI file with the data.

 

Thanks!

2 REPLIES 2
dcgwol
Regular Visitor

Hi, have you already figured out if there's a way to do this? I'm having the exact problem as you have. Thanks! 

Greg_Deckler
Community Champion
Community Champion

Use the disconnected table trick:

 

https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...

 

You would have 2 "Measures to Display" measures in your case. Probably 3 now that I think about it, one for each of the items in your slicer.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

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.

Top Solution Authors