Forum Discussion

NielsFro's avatar
NielsFro
New Member
4 years ago
Solved

Create a new table with measures and a different layout

Hi folks,   I'm new to PowerBI and guess that my question can be answered rather easily by the experts here. I apologize upfront if this has been answered elsewhere - I just don't know the correct ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    4 years ago

    If you unpivot your data, it will make your analysis and visualization much easier. In the query editor, select your first column, right click the header and choose "Unpivot Other Columns". This will give you three columns instead of four (People, Attribute, and Value - you can rename as needed).  You can then write fewer measures (e.g., avg, min, max of your value column), and then use the attribute column as the legend in visuals and/or columns in a matrix.

     

    Pat

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

If you unpivot your data, it will make your analysis and visualization much easier. In the query editor, select your first column, right click the header and choose "Unpivot Other Columns". This will give you three columns instead of four (People, Attribute, and Value - you can rename as needed).  You can then write fewer measures (e.g., avg, min, max of your value column), and then use the attribute column as the legend in visuals and/or columns in a matrix.

 

Pat