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.
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.