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!

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

Appreciating

For 2nd question, it's ok

For the 1st question (Pivot), the design of the option (Pivot column) is limited as per the below details:

1 - Only 2 dimensions (Columns & values), there was no rows as excel.

2 - it's in an oppoit structure as the field that i pivoted will be the header of columns but we need to be the 1st column.

3 - No possibility to make oulined table e.g. (Item code - Item Name) then we could aggregate other results (Sum of Q - Sum of Slaes, etc) as in excel

Anonymous's avatar
Anonymous
Not applicable
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!