Forum Discussion

Maahmohammed's avatar
Maahmohammed
Icon for Helper I rankHelper I
2 years ago
Solved

Pivot

Upon using Matrix to develop a pivot table, how could I save this pivot table as a new table in my Power BI data base? At the same time, when I select 2 fields in the row segment, they become one ov...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Maahmohammed ,

     

    When you do a pivot in Power BI, there are really only two main dimensions: columns and values. This is different from the pivot table in Excel, which has three dimensions: rows, columns, and values. This difference is mainly due to the different design concepts and usage scenarios of Power BI and Excel.

     

    For the first problem, you can just export the data of the original matrix in Power BI desktop:

    Then import the resulting excel file into desktop again.

     

     

    If I misunderstood you, please provide your data, screenshots and expected results so that your problem can be better solved.

     

    Best Regards,
    Zhu
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Maahmohammed ,

 

Based on your description, I created the simple matrix:

For your first question, here is the solution in Power Query Editor:

 

1.Duplicate the original table:

 

 

2.Select the fields used in the matrix and remove other columns:

 

 

3.Pivot the Year column and you can get the desired outcome:

 

 

4.Apply the steps and get a new table:

 

 

Regarding the second question, my understanding is to show the subcategories in the hierarchy below each parent in a separate column. Is this consistent with the results you want?

 

It can be set in the visualizations pane:

 

 

The effect is shown below:

 

 

Best Regards,
Zhu
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!