Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
Show and Tell
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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

    listing_two_columns_under_one_sub_column

     

    Best Regards,

    Dale

RajatJaiswal's avatar
RajatJaiswal
Frequent Visitor
8 years ago

Use unpivot feature 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Rajat , somehwat like this:

     

     

     

     

     Is this possible?

    • RajatJaiswal's avatar
      RajatJaiswal
      Frequent Visitor
      8 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        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?