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         1 ; 8 

 

When I try to visualise this data, PBI does not recognise that 2 and 5, and 1 and 8, are separate and need to be counted separately. Instead, it will list these as their own category.

 

Have tried split functionality but it does not work as it inflates the amount of ID no. etc. 

 

Thanks

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.

1 Reply

  • nandukrishnavs's avatar
    nandukrishnavs
    Community 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.