Forum Discussion

niko18033's avatar
niko18033
Icon for Helper I rankHelper I
6 years ago

Column to toggle between single or multiple categories

I want to create a column that allows me to toggle between emails associated with single or multiple clients (categories). I have a stacked column chart with the following fields.   Axis: 'Email' ...
Anonymous's avatar
Anonymous
Not applicable
6 years ago
As I said above, you have to add an attribute to your table that for each email will tell you whether it's a 'single' one or 'multiple' one. Then and only then will you be able to slice via this attribute and the x-axis of your visual will adjust accordingly.
niko18033's avatar
niko18033
Icon for Helper I rankHelper I
6 years ago

Thanks for the follow-up, Anonymous . What would be the best way to create such an attribute? Through Power Query Editor and doing a 'Group By' aggregation? Or a conditional column? I was thinking of just writing a DAX column, but am unsure how to define this.