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.
Looking for a helping hand. I've got a table that looks like this:
Project Member
1 John
1 Jane
2 John
3 Bob
3 Jane
3 Sue
I'd like to display it in Power BI like this:
Project Member 1 Member 2 Member 3
1 John Sue
2 John
3 Bob Jane Sue
I've tried using a Matrix display, but it basically will list out every name that is possible as columns. Just hoping that someone may have an idea of how this could be accomplished. Thanks in advance!
Solved! Go to Solution.
Hi @Macros ,
Not sure if the order counts for anything but you can add the following calculated column to your table:
Member ID = "Member " & CALCULATE ( COUNTROWS ( Table1 ); ALLEXCEPT ( Table1; Table1[Project] ); Table1[Member] <= EARLIER ( Table1[Member] ) )
Then add this to a matrix with this column on Columns:
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português
That's exactly what I was looking for! I could do it with Excel in roughly the same manner, but I just couldn't figure out how to get DAX to get me the Member Number that I could assign to a column.
Thanks so much for your help!
Hi @Macros ,
Not sure if the order counts for anything but you can add the following calculated column to your table:
Member ID = "Member " & CALCULATE ( COUNTROWS ( Table1 ); ALLEXCEPT ( Table1; Table1[Project] ); Table1[Member] <= EARLIER ( Table1[Member] ) )
Then add this to a matrix with this column on Columns:
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsPower Query > Tab Transform > Unpivot Columns
@Anonymous- Thanks for the suggestion, but it doesn't seem to work how I'd like it to look Still, I really appreciate your time!
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |