Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Accessing Data using Slicers

hi there, I have a table of customer shopping list, there is a column called Category where for instance a customer bought 2 items of different category ( example : clothing and food & beverages). Th...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    Anonymous , To resolve this split the category in Power Query

    plit the Column by Delimiter:

    Select the "category" column.
    Go to the "Transform" tab, click on "Split Column," and choose "By Delimiter."
    Choose the delimiter (in your case, it seems to be a comma followed by a space ", ").
    Unpivot the Columns:

    After splitting, you will have multiple columns for categories.
    Select the columns that were created from the split.
    Go to the "Transform" tab and click on "Unpivot Columns."
    Rename Columns:

    Rename the resulting columns to something meaningful, like "category" and "value."

     

bhanu_gautam's avatar
bhanu_gautam
Super User
2 years ago

Anonymous , To resolve this split the category in Power Query

plit the Column by Delimiter:

Select the "category" column.
Go to the "Transform" tab, click on "Split Column," and choose "By Delimiter."
Choose the delimiter (in your case, it seems to be a comma followed by a space ", ").
Unpivot the Columns:

After splitting, you will have multiple columns for categories.
Select the columns that were created from the split.
Go to the "Transform" tab and click on "Unpivot Columns."
Rename Columns:

Rename the resulting columns to something meaningful, like "category" and "value."

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    thank you so much!