Forum Discussion

quintama's avatar
quintama
Frequent Visitor
9 years ago
Solved

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: 

 

 

 

Any ideas?

 

 

Thanks!