Forum Discussion

Macros's avatar
Macros
Frequent Visitor
7 years ago
Solved

Visualize Vertical Table Horizontally

Looking for a helping hand.  I've got a table that looks like this:   Project         Member 1                   John 1                   Jane 2                   John 3                   Bob ...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    Hi Macros ,

     

    Not sure if the order counts for anything but you can add the following calculated column to your table:

    Member ID =
"Member "
    & CALCULATE (
        COUNTROWS ( Table1 );
        ALLEXCEPT ( Table1; Table1[Project] );
        Table1[Member] <= EARLIER ( Table1[Member] )
    )

    Then add this to a matrix with this column on Columns:

     

     

    Regards,

    MFelix

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power Query > Tab Transform > Unpivot Columns

  • Macros's avatar
    Macros
    Frequent Visitor
    7 years ago

    Anonymous- Thanks for the suggestion, but it doesn't seem to work how I'd like it to look  Still, I really appreciate your time!