Forum Discussion
Solved
Stacked column chart based on different slicers
I am trying to create a stacked column chart with values that change depending on selections from three different slicers. My data looks like this: I have three slicers to select the i...
KrisM , You have new table Summary and category has row values category 1, category2 etc
Then this should work as measure with Category from the summary on the axis
Sum by category = Switch( True() Max(Summary[Category]) = "Category 1", sum('Category 1'[Value], Max(Summary[Category]) = "Category 2", sum('Category 2'[Value]), Max(Summary[Category]) = "Category 3", sum('Category 3'[Value]) )
KrisM , You have new table Summary and category has row values category 1, category2 etc
Then this should work as measure with Category from the summary on the axis
Sum by category = Switch( True()
Max(Summary[Category]) = "Category 1", sum('Category 1'[Value],
Max(Summary[Category]) = "Category 2", sum('Category 2'[Value]),
Max(Summary[Category]) = "Category 3", sum('Category 3'[Value])
)
Sorry just saw you said it should be a measure not a column... That worked, thanks.