Forum Discussion
Working with data extracted from a SharePoint list
New to Power BI and Im currently trying to take some data from a SharePoint list and work with it in power BI. The list is basically a product tracker, and the column im having issues with is supposed to track the distribution month of a product. I've used the "choice" option in SharePoint lists to allow users to select the months the product will distributed in (attached photo shows what I mean). I realise this may not be the most elegant solution but as I mentioned Im new to the software and this seemed like a fine solution (at the time).
Id like to take this data and create a dashboard that shows which months have the highest volume of interactions with our different audiences. My issue is that once I get this data into power BI, all the data from the "choice" columns shows up as [List] in power query and I cannot figure out how to work with it unless I extract the values, which delimits it like January,February,March,...etc., but then makes it very difficult to work with.
All advice appreciated.
My advice is to avoid working with choices (lists) unless you accept the deal that comes with it. My suggestion is to indeed extract the values. You can join them into a single row if that works for you. You can use inspiration from these 3 sources to do that: Video 1 , Video 2,, Community Post (check for Jakinta's response)
1 Reply
My advice is to avoid working with choices (lists) unless you accept the deal that comes with it. My suggestion is to indeed extract the values. You can join them into a single row if that works for you. You can use inspiration from these 3 sources to do that: Video 1 , Video 2,, Community Post (check for Jakinta's response)