How to work with SharePoint Multi-value Columns in Power BI
Picking up from last post
In our last blog post, How to Data Mine SharePoint with Power BI, we showed you how to connect to a SharePoint list with Power BI, fix some known issues, and provide the basics.
In this post, we are expanding on that post by addressing how to work with multi-value columns in SharePoint.
What are Multi-value Columns?
Multi-value columns in SharePoint are lookup columns that allow the user to select more than one value. They appear to the user as a list of checkboxes. For example, you could have a list of products and enable the user to select multiple products.
Start well with our approach to designing Power BI Content!
Scenario
In the video below, we’ll show you how to access the multi-value column data. Then you’ll learn how to set up the model to enable filtering. In the product example, we want to filter by product and show related records, no matter how many products are selected. Now, you’ll know how to do this.
July 08, 2021 at 9:42 pm, Agnaldo said:
Very very good video, but I need your help, im my case , the list is a lookupvalue and I don´t know how to do .
April 14, 2023 at 2:10 am, Jody M Fox said:
OMG you made my day with this. Thank you so much!