cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

New Member

## 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 keywords to look for what I need 🤐

Here's my challenge.

I have a table that looks more or less like this (I picked random numbers only for clarification).

 People Information 1 Information 2 Information 3 ... Adam 1 6 7 Angela 6 2 2 Michael 4 7 2 Joe 3 3 6 Lena 6 1 7 ...

I create different measures for each Information column. e.g. Avg, Min, Max, Standard deviation etc.

What I'd like to have in the end is a table that is somehow "shifted" and only holds these calulated measures per Information, looking like this (more or less):

 Information Avg Min Max SD ... Information 1 4,00 1 6 2,121 Information 2 3,80 1 7 2,588 Information 3 4,80 2 7 2,588 ...

Doing this in Excel would be easy for me, but in PowerBI.... well... I'm looking forward to your replies 🙂

1 ACCEPTED SOLUTION
Microsoft

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

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

@mahoneypa HoosierBI on YouTube

3 REPLIES 3
New Member

Thanks again, @mahoneypat . This is magic to me 😄 happy Friday, happy weekend!

New Member

Thanks a lot for your quick answer! I'm going to look into that right now 🙂

Microsoft

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

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

@mahoneypa HoosierBI on YouTube

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors