Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, This in Nobuko_ao. very new user of Power BI.
I need your help to creating some chart with Power BI.
We would like to analyze our client’s “aptitude test” results (Over 3,000 lines), and create a summary with Power BI.
The data format of aptitude test are as follows;
Basically we have no idea to doing preliminary preparation with excel file, like as copy & past with switching cell(column) and row.
1) How do we make a chart A), with most simple and efficient way with Power BI?
2) How do we make a chart B), with most simple and efficient way with Power BI?.
3) How do we calculate “descriptive statistics value”, and make a chart C) with Power BI?
4) If using Power BI is not the efficient/productive way, please advise the best tools to make these chart,
e.g. using R, or anything else.
Many thanks in advance.
Nobuko_ao
Solved! Go to Solution.
Right click [ID] column and select Unpivot Other Columns in Query Editor, then you may use Line chart and Box and Whisker chart.
Right click [ID] column and select Unpivot Other Columns in Query Editor, then you may use Line chart and Box and Whisker chart.
Dear Sam,
I did it with your advise. Thanks !!
Chart A) and Chart B) are solved.
Do you have any idea regarding calcurate “descriptive statistics value”, and make a chart C) ?
My boss mentioned that it would be better to using "R" for Chart C), do you agree?
Many thanks in advance,
Nobuko_ao
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |