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

How to calculate "descriptive statistics value" and make Chart

Dear All,

 

I would like to calculate  "descriptive statistics value" from data A) as below, 

and make a Chart B).

 

Data A)

Data.png

 

 

 

 

Chart B)

Chart C.png

 

 

 

 

 

Would you please show me the way to make it.

 

Also, if Power BI is not the efficient tools to make this chart, please advise

the best way.

MY boss mentioned that "It would be better/easy  to use 'R', and

copy the chart to Power BI's Dashboard". Is it correct?

 

Many thanks in advance,

 

Nobuko_ao

1 ACCEPTED SOLUTION

Accepted Solutions
anandav Established Member
Established Member

Re: How to calculate "descriptive statistics value" and make Chart

@Nobuko_ao,

A "limited" way of doing this is below but not all the prescriptive functionas are possible. This is only a suggestion and I understand this may not fullfil your full requirement but may give you some ideas.

 

Sam.jpg

 

 

5 REPLIES 5
anandav Established Member
Established Member

Re: How to calculate "descriptive statistics value" and make Chart

@Nobuko_ao,

 

You coulduse the DAX statistical functions. Check the DAX reference https://msdn.microsoft.com/query-bi/dax/statistical-functions-dax.

You can write Measures to display the required info in a table.

 

You can't cut and paste R graphs into Power BI. YOu will need to write R script in Power BI to generate the visuals.

 

Hope this helps.

Nobuko_ao Frequent Visitor
Frequent Visitor

Re: How to calculate "descriptive statistics value" and make Chart

Hi, Anandav,

 

Thank you for your prompt reply.

 

I know that DAX can calculate each nubmer, e.g. MAX, Average and so on.

 

But in Excel, I can calculate all numbers for "objectivity", as like as Chart b)'s "Objectivity"

with one action.

 

Using DAX (writing Measure) , I should calculate MAX for objectivity, MIN for objectivity,

Average for objectivity,  ... then make a chart, am I correct?

 

If so, I cannot calculate all numbers for objectivity with one action like as Excel, right?

 

best

 

 

 

Data.png

 

 

anandav Established Member
Established Member

Re: How to calculate "descriptive statistics value" and make Chart

@Nobuko_ao,

Yes, you will have to write different measures or calucluated columns (using an unpivoted table of the data table).

Sorry, I don't know of any other way.

anandav Established Member
Established Member

Re: How to calculate "descriptive statistics value" and make Chart

@Nobuko_ao,

A "limited" way of doing this is below but not all the prescriptive functionas are possible. This is only a suggestion and I understand this may not fullfil your full requirement but may give you some ideas.

 

Sam.jpg

 

 

Highlighted
Nobuko_ao Frequent Visitor
Frequent Visitor

Re: How to calculate "descriptive statistics value" and make Chart

@anandav,

 

Thank you for your reply. I understood.

I will seek another way to make "descriptive statistics value" chart, asking my boss.

 

Many Thanks,

 

best

 

Nobuko_ao