Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
NielsFro
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).

 

PeopleInformation 1Information 2Information 3...
Adam167 
Angela622 
Michael472 
Joe336 
Lena617 
... 

 

  

 

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):

 

InformationAvgMinMaxSD...
Information 14,00162,121 
Information 23,80172,588 
Information 34,80272,588 
...     

 

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

1 ACCEPTED SOLUTION
mahoneypat
Employee
Employee

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!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

3 REPLIES 3
NielsFro
New Member

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

NielsFro
New Member

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

mahoneypat
Employee
Employee

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!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.