Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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....
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Anonymous 
    Are you expecting something like this?

     

     

     

    Paul Zheng _ Community Support Tea

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Have two columns One for A and one for B

 

Have a city table with the group where you have rows for both A and B, you need to create a many to many birection join to filter

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      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.

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        amitchandak Sorry dear all the data is sensitive can't share.

         

        And how to separate it with comma? Can you please help with this?