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.
Hi there, i need some help creating a table.
I have data in tabular way, as shows in picture 1, and i need to create a overview table with a deviation column like i show in second picture
Is any way to create this ? i guess it might work with double pivoting? but i'm not sure.
Please help 😄 thank you very much
Solved! Go to Solution.
Hi @plaralema ,
You need to unpivot columns first, then spilit an attribute column by space, and then pivot again.
Detailed steps:
1.Select the four columns and click "Unpivot Columns".
2.Split by space.
3.Select the Attribute.1 column and then click "Pivot Column".
4.Set up as follows and click OK.
Final result is as follows. It's displayed as a matrix visual.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you a lot for your detailed expression, i'll try it right away!
Hi @plaralema ,
You need to unpivot columns first, then spilit an attribute column by space, and then pivot again.
Detailed steps:
1.Select the four columns and click "Unpivot Columns".
2.Split by space.
3.Select the Attribute.1 column and then click "Pivot Column".
4.Set up as follows and click OK.
Final result is as follows. It's displayed as a matrix visual.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |