how do we make some specific charts with Power BI

[Nobuko_ao]

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

[v-chuncz-msft · Accepted solution]

@Nobuko_ao,

Right click [ID] column and select Unpivot Other Columns in Query Editor, then you may use Line chart and Box and Whisker chart.

[Nobuko_ao]

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