Forum Discussion

yushengsoon's avatar
yushengsoon
Regular Visitor
9 years ago
Solved

Matrix Rows not grouping properly

Hi,   Usually when using a Matrix, the values will get summarised (in my case I used SUM) based on the Row name. However, in my instance, it doesn't, i.e. it will show a duplicate value   Name   ...
  • yushengsoon's avatar
    yushengsoon
    9 years ago

    Hi Guavaq,

     

    Visually there wasn't anything we could see different between both columns. The only conclusion was data corruption but somehow excel pivot table is fine but Power BI matrix doesn't. The final solution was to reimport the data from the original system into excel (no connectors to Power BI) and then refresh it in Power BI; this then suddenly magically worked..... :) Thanks for your swift response though.

yushengsoon's avatar
yushengsoon
Regular Visitor
9 years ago

Hi Guavaq,

 

Visually there wasn't anything we could see different between both columns. The only conclusion was data corruption but somehow excel pivot table is fine but Power BI matrix doesn't. The final solution was to reimport the data from the original system into excel (no connectors to Power BI) and then refresh it in Power BI; this then suddenly magically worked..... :) Thanks for your swift response though.

GilbertQ's avatar
GilbertQ
Super User
9 years ago
Glad you got it working :)