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
Ecerv255
Regular Visitor

Statistics Table

Hello,

 

I'm attempting to make a stastictics table visualization that aggregates 4 Fields (rows) as columns for each aggregation (1 column for averages, min, max, median.

 

Data:

 

FORM_BREAK_PRESSUREINSTANT_SI_PRESSURETREATMENT_TEMPERATUREFRAC_GRADIENT
38.231.747.332
39.93247.733.5
40.331.447.831.4
40.831.247.932.2
4132.54832
41.232.548.132.5
41.432.548.234.5
42.131.848.633.3

 

What I want:

 

 MinMax AvgMedian
FORM_BREAK_PRESSURE    
INSTANT_SI_PRESSURE    
TREATMENT_TEMPERATURE    
FRAC_GRADIENT    

 

Thanks for your help!

 

1 ACCEPTED SOLUTION
SteveCampbell
Memorable Member
Memorable Member

You could unpivot your data. Open power query,  highlight all columns, right click and unpivot. This will give you attribute and value. You can add Attribute to the rows of a table, then drag in value four times and change the summarization to the correct measure.

 

Appreciate your Kudos
Connect with me!

Stay up to date on  linkedin-logo.png
Read my blogs on  powerbi.tips_.png

 

 



Did I answer your question? Mark my post as a solution! Proud to be a Super User!


Connect with me!
Stay up to date on  
Read my blogs on  



View solution in original post

2 REPLIES 2
SteveCampbell
Memorable Member
Memorable Member

You could unpivot your data. Open power query,  highlight all columns, right click and unpivot. This will give you attribute and value. You can add Attribute to the rows of a table, then drag in value four times and change the summarization to the correct measure.

 

Appreciate your Kudos
Connect with me!

Stay up to date on  linkedin-logo.png
Read my blogs on  powerbi.tips_.png

 

 



Did I answer your question? Mark my post as a solution! Proud to be a Super User!


Connect with me!
Stay up to date on  
Read my blogs on  



Anonymous
Not applicable

Hi,

Thank you for this help.

Is it possible to copy the data before unpivot it in order to obtain a file of the form?

FORM / INSTANT / TREATMENT / TEMPERATURE / FRAC / ATTRIBUTE / VALUES

38.2 / 31.7 / 47.3 / 32 / FORM / 38.2

39.9 / 32 / 47.7 / 33.5 / INSTANT / 31.7

etc

Thanks 🙂

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.