Forum Discussion
Grouping one value in two groups
I am trying to group data of a column. I want to group one value in two groups, how to do it? For Example: I am creating new column of group called Z. The column has multiple cities name of USA....
Anonymous
Are you expecting something like this?Paul Zheng _ Community Support Tea
amitchandak Thanks for your reply.
1.Imagine I have 100s of rows of data. I cannot create different columns for issues like this. The number of columns will get increasing for large data.
2. I want to use this column Z as slicer to filter data according to the grouping.
Anonymous , You can have comma separated.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
amitchandak Sorry dear all the data is sensitive can't share.
And how to separate it with comma? Can you please help with this?