Multiple Choice displayed through Power BI

[Dogle]

Hi,

I have an issue with data from a multiple choice column in Microsoft Lists where more than one selection is made.

When trying to output this back into a visual report throuugh Power BI, I am left with something like this:

I would like to be able to view data as:

Asset Condition

Private Property

rather than..

Asset Condtiion, Private Property.

Whilst also having the funtionality to drill through back into the table below showing all relevant items related to the likes of "Asset Condition" etc.

Splitting the data in the columns using delimiter split only makes the data more confusing to digest as will have multiple items covering one topic.

Hope this isnt too confusing. Im reletavely new to Power BI and its assosiated apps so any assistance would be appreciated.

Thanks,

D

[lbendlin · Accepted solution]

split into rows, not into columns.