Forum Discussion

LucasResendeR10's avatar
LucasResendeR10
Frequent Visitor
2 years ago
Solved

Associate term in column divided by delimiter to a numeric column

Hello there! Hope you're all fairing well. I'm having trouble with a column with terms divided by a delimiter. I want to associate each of the terms with a specific numeric column for that term, so ...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    LucasResendeR10 , Try below method

     

    Step 1: Split the Terms Column
    Go to Power Query Editor.
    Select the "Terms spent on" column.
    Use the "Split Column" feature by delimiter (comma in this case).
    Step 2: Unpivot the Data
    Select the columns "Money spent on Term 1", "Money spent on Term 2", "Money spent on Term 3", and "Money spent on Term 4".
    Use the "Unpivot Columns" feature.
    Step 3: Create Relationships
    Create a new table with unique terms (Term 1, Term 2, Term 3, Term 4).
    Create a relationship between the unpivoted data and this new table based on the terms.
    Step 4: Use a Slicer
    Add the unique terms table to your report.
    Create a slicer visual using the terms from the unique terms table.

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
2 years ago

LucasResendeR10 , Try below method

 

Step 1: Split the Terms Column
Go to Power Query Editor.
Select the "Terms spent on" column.
Use the "Split Column" feature by delimiter (comma in this case).
Step 2: Unpivot the Data
Select the columns "Money spent on Term 1", "Money spent on Term 2", "Money spent on Term 3", and "Money spent on Term 4".
Use the "Unpivot Columns" feature.
Step 3: Create Relationships
Create a new table with unique terms (Term 1, Term 2, Term 3, Term 4).
Create a relationship between the unpivoted data and this new table based on the terms.
Step 4: Use a Slicer
Add the unique terms table to your report.
Create a slicer visual using the terms from the unique terms table.