Forum Discussion
Multiple Choice displayed through Power BI
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
split into rows, not into columns.
1 Reply
- lbendlinSuper User
split into rows, not into columns.