Forum Discussion

Aron_Moore's avatar
Aron_Moore
Solution Specialist
7 years ago
Solved

Matrix vs Pivot Table

Hello,   Any idea why a matrix in Power BI would not show the same result as a pivot in excel? The excel is reading from the Power BI dataset published in the service.     Looking at t...
Need Help
  • Aron_Moore's avatar
    Aron_Moore
    7 years ago

    Turns out there was blank rows. Not sure how I missed them, especially since I check with the filters.

     

    Thanks all!

v-diye-msft's avatar
v-diye-msft
Community Support
7 years ago

Hi Aron_Moore 

 

The blank cell actually represents the total items , you could change the option setting if you’d like to show the same visual as Matrix:

Uncheck the “Classic PivotTable Layout”

Best regards,

Dina Ye

  • Aron_Moore's avatar
    Aron_Moore
    Solution Specialist
    7 years ago

    Turns out there was blank rows. Not sure how I missed them, especially since I check with the filters.

     

    Thanks all!