cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Nobuko_ao Frequent Visitor
Frequent Visitor

how do we make some specific charts with Power BI

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;

Data.pngChart A.pngChart B.pngChart C.png

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: how do we make some specific charts with Power BI

@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.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: how do we make some specific charts with Power BI

@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.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Nobuko_ao Frequent Visitor
Frequent Visitor

Re: how do we make some specific charts with Power BI

Chart 0405.PNG

 

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