How to work with SharePoint Multi-value Columns in Power BI

by Treb Gatte

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.

Multi-value Column User Interface

Want to know more about Power BI with SharePoint?

We have opened a waitlist for a new online class, “How to Use Power BI to Access and Visualize SharePoint Business Data.”

Sign up for the waitlist here and we’ll notify you when the class is available.


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.

2 Responses to “How to work with SharePoint Multi-value Columns in Power BI”

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 .

Reply

April 14, 2023 at 2:10 am, Jody M Fox said:

OMG you made my day with this. Thank you so much!

Reply

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.