Forum Discussion

ironryan77's avatar
ironryan77
Kudo Commander
9 years ago

Changing axis in matrix

How do I change axes in a matrix so that my rows become columns and vice versa?  Currently I have a date_string value as my Rows, and the other aggregates as Values.  But when I try adding this date_...
Need Help
PavelR's avatar
PavelR
Solution Specialist
9 years ago

Hi ironryan77.  Use Pivot column function in Query editor.

 

Regards.

Pavel

ironryan77's avatar
ironryan77
Kudo Commander
9 years ago

Thanks, Ravi.  does Pivot Column only work one column at a time?  I tried using this function, but I couldn't figure out how to aggregate the data.  After doing Pivot Column and choosing one of the metrics to pivot on, it still listed all of my metrics in the header row instead of column row.  "Transport Month" is the name of my date_str column that I want to pivot, and Total_Volume is the name of one of my metrics that I want listed in one row instead of one column.  

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    9 years ago

    hi ironryan77

     

    Follow this steps:

     

    1.Your original table

     

     

    2.Select A,B,C  and click to Unpivot Columns

     

    the results is:

     

     

     

    2.Select Date_Str and click to Pivot Column

     

     

     

    And the results is:

     

     

     

    • ironryan77's avatar
      ironryan77
      Kudo Commander
      9 years ago

      Thank you Victor.  I actually have more than one Attribute column; will Pivot Column still work in this case?  Or do I need to string all of my Attribute Columns together into one column to use as the Pivot?

      Also, I couldn't figure out which Value to Pivot on.  (I have more than one Value column too).  When I tried Pivoting on just one Value column, I got this error below (Transport Month was my date_str column):

       

      This was the error details:

      Error Message:

Something's wrong with one or more fields: (Payor_Scorecard_All_Payors_Final_PROD) Transport Month

Stack Trace:



Invocation Stack Trace:



Activity ID
20eaf971-21ad-d55b-4801-d5fbcea2fc5a

Time
Wed Oct 05 2016 13:58:38 GMT-0500 (Central Daylight Time)

Version
2.38.4491.282 (PBIDesktop)

Client Error Code
Missing_References

       

       

      • Vvelarde's avatar
        Vvelarde
        Community Champion
        9 years ago

        ironryan77

         

        Can you put some sample table and the result that you expected?

         

        With this input i'll try to think a solution.