Multiple options in one column

[millie23]

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

[nandukrishnavs · Accepted solution]

@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.