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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
quintama
Frequent Visitor

Using Slicers to Choose Which Measure to Display

Hi All,

I am trying to custom a graph so that the user can select what measures he can see in the graph. I was able to do this by creating a Switch measure: 

 

Selected Measure = SWITCH(FIRSTNONBLANK(Options[Tipo],Options[Tipo]),"CBB",SUM(Custos[CBB]),"Receita",SUM(Custos[Receita]),"Custo",SUM(Custos[CustosNeg]))

 

However I would like that the user be able to select multiple options (not only switch) 

 

Example below: 

 Capture1.PNGCapture2.PNG

 

 

Any ideas?

 

 

Thanks!

1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

2 REPLIES 2
Sean
Community Champion
Community Champion

Take a look here... I believe this is what you want

http://community.powerbi.com/t5/Video-Tips-and-Tricks/Turn-Measures-On-and-Off-Inside-a-Chart-with-C...

Hope this helps! Smiley Happy

quintama
Frequent Visitor

Thanks!! This worked perfectly well 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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