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

 

 

View solution in original post

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.

Highlighted
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

 

 

View solution in original post

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

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 79 members 1,341 guests
Please welcome our newest community members: