Using Slicers to Choose Which Measure to Display

[quintama]

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: 

 

Any ideas?

Thanks!

[Sean · Accepted solution]

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!

[quintama]

Thanks!! This worked perfectly well 🙂