Slicer showing [List] instead of values from SharePoint List

[asbajaj001]

Hi,

I have data in a SharePoint List. Some columns within SharePoint List are list themselves. I am trying to show the values within the "SolutionArea" column for example as values in the slicer control in PBI. However, it says, "List". How do I get the values to show there?  

[amitchandak]

@asbajaj001 , refer these solutions

https://www.edureka.co/community/38747/expand-all-lists-lists-the-same-time-without-recurring-values

https://community.powerbi.com/t5/Power-Query/Expand-a-Column-of-quot-List-quot-and-quot-Record-quot/...

https://powerbi.microsoft.com/en-us/blog/how-to-expand-a-list-of-records-in-a-query/

[AllisonKennedy · Accepted solution]

@asbajaj001  Try following this method from within Power Query: https://powerbi.microsoft.com/en-us/blog/how-to-expand-a-list-of-records-in-a-query/ 

If that doesn't work, please let us know what the differences are or where it's getting stuck. 🙂