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.
For a table like below
Name | Physics | Maths |
Vikas | 88 | 90 |
Aakash | 85 | 97 |
Ravi | 89 | 91 |
I want Both Physics and Math to be under one column as “ Subject” as sub column. How can it be done?
Solved! Go to Solution.
Hi @Anonymous,
Yes, you can achieve this by adding a new table like below. And other parts are like @RajatJaiswal's solution. Please check out the demo in the attachment.
Class Course
Subject | Physics |
Subject | Maths |
Best Regards,
Dale
Use unpivot feature
= Table.UnpivotOtherColumns(#"Changed Type", {"Name"}, "Attribute", "Value")
Hi Rajat , somehwat like this:
Is this possible?
@Anonymous
If I understand correctly after reviewing your picture. I don't think it is possible. As it is columnar data so column physics & Maths should be different but if you want to show a report in power BI then we can think of it. Please, share what exactly you need and is it report view or data source table.
yes if it is possible to show report in powerBI and aslo if it is possible to get that as view in tabular form in report? as in visualization?
Hi @Anonymous,
Yes, you can achieve this by adding a new table like below. And other parts are like @RajatJaiswal's solution. Please check out the demo in the attachment.
Class Course
Subject | Physics |
Subject | Maths |
Best Regards,
Dale
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |