Forum Discussion

erikskov's avatar
erikskov
Icon for Advocate II rankAdvocate II
11 years ago

can you pivot data values from column to on row

Withing Power BI creating a report from a published data source, can you pivot the matrix view to get values on row instead of the defaul values on column?  The desired functionality is identical to ...
andre's avatar
andre
Icon for Memorable Member rankMemorable Member
11 years ago

The Matrix control in the Service is lacking some of the features of the Excel matrix control (like pivoting on columns).  Hopefully all of the missing features will make it back into the service soon.

  • konstantinos's avatar
    konstantinos
    Icon for Memorable Member rankMemorable Member
    11 years ago

    You can change fields from rows to columns in on a Matrix when Editing report

     

     

    Untitled.png

    • curbinag's avatar
      curbinag
      New Member
      10 years ago

      Hi...

       

      But konstantinos, the problem is: if you change '[Name]' from rows to columns, the measures [Value] and [Value2] always is in the columns... 

       

      I want show:

      ---------- NameA, NameB, NameC

      Value           10           20         30 

      Value2         40           50         70

      • david2's avatar
        david2
        Icon for Helper I rankHelper I
        10 years ago

        did you ever find a solution for this?