Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |