Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi all,
I have the data sets as follows:
Project Name Needed Resource
Project A Resource A
Project A Resource B
Project A Resource C
Project A Resource D
Project B Resource A
Project B Resource B
Project C Resource A
Project C Resource B
Project C Resource D
Project D Resource B
Project D Resource C
Project D Resource D
Project D Resource E
Project E Resource A
Project E Resource B
project E Resource E
I want to set a parameter, when parameter is 2, the result is as follows:
Project Name with same resource group (resource number in the group =2) Resource Group
Project A, Project B, Project C, Project E Resource A,B
Project A, Project D Resource B,C
Project A, Project C Resource A,D
Project A, Project C, Project D Resource B,D
Project D, Project E Resource B,E
And I also want to create the table for resource number in the group =3,4,5,6...
Does anyone who know how to do it? Thanks in advance!
Solved! Go to Solution.
You are likely better off using a graphical solution.
User | Count |
---|---|
14 | |
9 | |
7 | |
7 | |
6 |
User | Count |
---|---|
21 | |
11 | |
10 | |
9 | |
8 |