Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Nobuko_ao
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

@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
Skilled Sharer
Skilled Sharer

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

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

 

 

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

@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

 

 

@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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.