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.

GilbertQ's avatar
GilbertQ
Super User
9 years ago

Hi yushengsoon


Can you confirm that your data type is set to a value that can SUM? (Whole Number, Decimal Number, etc...)

  • yushengsoon's avatar
    yushengsoon
    Regular Visitor
    9 years ago

    Hi guavaq,

     

    Yes, they are in Currency. If I change the Row Name to a different column to group by it works, but when I switch it back it doesn't.

    • GilbertQ's avatar
      GilbertQ
      Super User
      9 years ago

      Ok thanks, then it would indicate that there is something different with the different columns?

       

      I would suggest having a look at what is different between the columns that do work and do not work. As without having a sample of your real data that is the best I can suggest.

      • 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.