Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
sambouhdary
Regular Visitor

Creating Visuals that filter through list data types

Hello,

 

I am trying to figure out the best way to work with list data structures in PowerBI. Presumably, there are multiple ways to do this, but I will first outline the what I am trying to accomplish, then the problem, since I haven't been able to resolve this issue.

 

I am trying to build a project overview dashboard in PowerBI. Each project has some data attached to is: Name, Description, Tags, Team (who is working on the project), Priority #, etc.

 

That last data point is where I am having issues. A project belongs to a given organizational priority (let's say there are five priorities). For example, imagine Project #1 belongs to priority # 2 & priority # 4. PowerBI has stored that as a list (see sample data image below).

 

Here is where the issue arises. How does one filter a list data structure? My goal is to create a pie chart visual that can filter all project by priority # (see image below). But as of now, I can figure out how to create a filter, measure, or calculated column that may be able to do this.

 

Might any of you have any guidance on this?

 

Sample Data.PNGSample Visual.PNG

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

1 REPLY 1
lbendlin
Super User
Super User

Recommended reading:

 

A hard lesson on Filter Context with Power BI and DAX | by Salvatore Cagliari | Towards Data Science

Row Context and Filter Context in DAX - SQLBI

 

In short - Filter context is a list of values - exactly what you need.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors