Forum Discussion

millie23's avatar
millie23
Frequent Visitor
3 years ago
Solved

Multiple options in one column

Hiya,    I am new to PBI.    I have a column in my data which offers multiple choice options, for example:   ID number       Offer   222222222         1 333333333         2 ; 5 999999999   ...
Need Help
  • nandukrishnavs's avatar
    nandukrishnavs
    3 years ago

    millie23 Follow the below steps.

     

    Step 1: Take reference of the main table

    Step 2: Select ID and Offer column and remove other columns

    Step 3: Split Offer column to rows. Then close and Apply

    Step 4: Enable relationship between newly created table and main table using ID column. Activate Both direction relationship.

    Step 5: Use Offer column from newly created table into the slicer.

nandukrishnavs's avatar
nandukrishnavs
Icon for Community Champion rankCommunity Champion
3 years ago

millie23 Follow the below steps.

 

Step 1: Take reference of the main table

Step 2: Select ID and Offer column and remove other columns

Step 3: Split Offer column to rows. Then close and Apply

Step 4: Enable relationship between newly created table and main table using ID column. Activate Both direction relationship.

Step 5: Use Offer column from newly created table into the slicer.