Forum Discussion

rshifflet's avatar
rshifflet
Frequent Visitor
9 years ago
Solved

Delimitate Column into Single Column

This may be a very simple thing, so please excuse my ignorance. I will try and articulate this the best that I can. When I go to edit my quiries, I have several columns with values that are comma del...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi,

     

    According  to your description, you want to spilt the “LSR’s “ column by “,” and merge them to one column, right?

     

    If as I said, you can follow below steps:

     

    Source table:


     

    1. Open the edit query and duplicate the base table:

     


     

    2. Right-Click on LSR’s and choose the “spilt column” -> “By Delimiter”:


     

     

     

     

    3.All select the columns and choose the “Unpivot Columns”:
     

     

     

    4.Modify the formula of "Unpivot Columns":

     

    Table.UnpivotOtherColumns(#"Changed Type1", {}, "Attribute", "Value")[Value]

     


     

    5. Close and apply the change, then create a visual.

     


     

    Regards,
    Xiaoxin Sheng

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

Split into two columns on comma. Make a hierarchy, Column1 at the top, Column2 below it and use that in your visual. This will activate drill down capabilities. Alternatively, you can use two treemaps, one for Column1 and one for Column2. Clicking on the Column1 treemap will automagically filter the other treemap.