cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

listing two columns under one sub column

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?

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @hardipinder,

 

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

listing_two_columns_under_one_sub_column

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Frequent Visitor

Use unpivot feature 

= Table.UnpivotOtherColumns(#"Changed Type", {"Name"}, "Attribute", "Value")unpivot.png

Hi Rajat , somehwat like this:

 

 

Capture.JPG 

 

 Is this possible?

@hardipinder

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 @hardipinder,

 

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

listing_two_columns_under_one_sub_column

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors