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,
Looking for some help:
The goal is re-shape data based on the ranking. All parts has rank 1 & 2 Only.
The desired outcome to transform the data into vertical table where rank2 items appearing on the left hand side.
Solved! Go to Solution.
Hi,
you can try the transformation listed in the attached file
and you obtain this
If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !
Thank you very much! Excellent solution. As I had to create two different tables, one with filter rank 1 and the other with filter rank 2, I created a unique attribute and joined the two tables. Your solution, however, is more effective.
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.