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.
I created a table contain 20 string columns, now I am trying to convert to matrix since I can frezze ID column like Excel. When I put string column in value filed. I have to aggrate the column. It caused some data was mssing. Is it possible to create measure, but doesn't aggreate string to show all info
ID | Category A | Category B | Category C |
1 | A | Q | A |
1 | B | W | S |
1 | E | E | D |
1 | D | Y | H |
1 | N | U | J |
Solved! Go to Solution.
Hi @Anonymous ,
As @parry2k said, the prerequisite for the transformation is that there needs to be a column that can be used as a separate identification column, and an index index column can be created in the power query. Then put its field into the column. Refer to the following operation:
If the problem is still not resolved, please point it out. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
As @parry2k said, the prerequisite for the transformation is that there needs to be a column that can be used as a separate identification column, and an index index column can be created in the power query. Then put its field into the column. Refer to the following operation:
If the problem is still not resolved, please point it out. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous If you have same id for all the rows, you cannot do anything, you need to have a unique column on the rows, maybe add a index column in the power query and use that on the rows.
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 |
---|---|
108 | |
98 | |
81 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |