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

Start well with our approach to designing Power BI Content!

Are you struggling to create powerful reports that your users will use to make better business decisions? Are you tired of being asked whether the report you delivered can be exported to Excel? If so, this book is for you.

Read the first chapter for free by clicking Preview.


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.