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
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_PRESSURE | INSTANT_SI_PRESSURE | TREATMENT_TEMPERATURE | FRAC_GRADIENT |
38.2 | 31.7 | 47.3 | 32 |
39.9 | 32 | 47.7 | 33.5 |
40.3 | 31.4 | 47.8 | 31.4 |
40.8 | 31.2 | 47.9 | 32.2 |
41 | 32.5 | 48 | 32 |
41.2 | 32.5 | 48.1 | 32.5 |
41.4 | 32.5 | 48.2 | 34.5 |
42.1 | 31.8 | 48.6 | 33.3 |
What I want:
Min | Max | Avg | Median | |
FORM_BREAK_PRESSURE | ||||
INSTANT_SI_PRESSURE | ||||
TREATMENT_TEMPERATURE | ||||
FRAC_GRADIENT |
Thanks for your help!
Solved! Go to Solution.
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
Read my blogs on
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
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
Read my blogs on
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
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 🙂
User | Count |
---|---|
158 | |
109 | |
96 | |
83 | |
75 |
User | Count |
---|---|
154 | |
137 | |
131 | |
81 | |
62 |