Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Create Histogram using Quartiles

Hi Everyone, I am looking at creating a histogram that will show the average tenure of employees by quartiles.    I used the below code to try and get quartiles however I can't seem to use this in...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi Anonymous ,

Can you please share a dummy file? If you can't, please share some sample data and your expected results that will make us understand clearly about your requirement.

 

Please see this post regarding How to Get Your Question Answered Quickly: 

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-xuding-msft , how is this?  and thanks for the reply.

 

sample data:

 

Employee ID            Tenure      Location

abc                               .4           A

def                              1.2           B

g                                  .5            B

h                                  5              A

i                                    4.2            B

 

Expected Results:

These are assigned quartiles dynamically which I can then put into a histogram.  So above another column of Quartiles/percentiles would be added but it can change depending on what location(s) you choose.  The histogram can be a bar chart but would look somethign like below.  Where the X axis are the quartiles and the Y axis is the employee count.

 

Does this help?